Load CSV status, when "Using Periodic Commit"


(Smtatman) #1

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


(Mike Morley) #2

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.


(Smtatman) #3

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


(Michael Hunger) #4

That should also show up in count queries.

e.g.

MATCH (:Label) RETURN count(*)

which should increase in 10k steps.