Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
01-06-2023 02:34 AM
I tried "neo4j-admin database import incremental" with Movie graph:
I'm using Neo4j enterprise server 5.3.0, apoc-5.3.0-extended
I enabled uuid in Movie and Person nodes as described in neo4j manual since it is required for incremental import:
1. run create Movie graph script found in :play movies
2. create constraint for (p:Movie) require p.uuid is unique
3. create constraint for (p:Person) require p.uuid is unique
...
4. call gds.graph.project('moviePerson', ['Movie', 'Person'], 'ACTED_IN')
5. call gds.beta.graph.export.csv('moviePerson', {exportName: 'movie-person', additionalNodeProperties: ['title', 'name', 'uuid']})
< nodes_Person_0.csv >
1,"Keanu Reeves",,"bf59b74a-9ac2-4c1f-8de7-b22be51f731a"
2,"Carrie-Anne Moss",,"c5642d98-09f7-4469-9efa-2606ea92ef9e"
3,"Laurence Fishburne",,"365c1fe3-9039-4a38-be9b-ec6fce9111b3"
....
< nodes_Movie_0.csv >
0,,"The Matrix","aeff74b8-8c0c-4d98-9395-9463af575602"
9,,"The Matrix Reloaded","8d69c33d-4d68-454c-85d7-ef222f8e6ebb"
10,,"The Matrix Revolutions","f2368b75-3ddd-45a3-95f7-de10a2f4a715"
....
< relationships_ACTED_IN_0.csv >
1,0
1,9
1,10
....
6. edit nodes_Movie_header.csv:
uuid:ID,name:string,title:string,uuid
7. edit nodes_Person_header.csv:
uuid:ID,name:string,title:string,uuid
8. neo4j-admin database import incremental --stage=all --nodes=Movie=import/export/movie-person/nodes_Movie_header.csv,'import/export/movie-person/nodes_Movie_\d+\.csv' --nodes=Person=import/export/movie-person/nodes_Person_header.csv,'import/export/movie-person/nodes_Person_\d+\.csv' --relationships=ACTED_IN=import/export/movie-person/relationships_ACTED_IN_header.csv,'import/export/movie-person/relationships_ACTED_IN_\d+\.csv' neo4j --force
And I got this error:
java.lang.IllegalStateException: No label was specified for the node index in 'uuid:ID'
I tried several different header column names like uuid:ID(Movie, Person) but only got other exception like org.neo4j.internal.batchimport.input.HeaderException: Group 'null' not found. Available groups are: [Movie;Person].
Usually I succeeded "import full" with the CSV files generated by "gds.beta.graph.export.csv", without modifying their header files.
Thanks and Happy New Year Community!
01-27-2023 02:36 PM
Hi, were you able to resolve this? I am facing a similar error when doing incremental import in EE v5.4.0?
All the sessions of the conference are now available online