cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Load CSV status, when "Using Periodic Commit"

I ran a query to load a csv that I terminated since it was taking too long.
Is there a way to tell how many rows of the csv were imported? And then restart the import from that location?

Below is the start of my query

USING PERIODIC COMMIT 10000
LOAD CSV WITH HEADERS FROM "file:///FILENAME.csv" AS row

3 REPLIES 3

mmorley
Node Clone

assuming its being imported linearly, one way I have done this is by adding a row number into the source CSV. Then you can query by row number in neo4j side to tell how far it got.

Thank you mmorley for advice would you set the row number somewhere or return its value in the original query?

That should also show up in count queries.

e.g.

MATCH (:Label) RETURN count(*)

which should increase in 10k steps.