cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! Site migration is underway. Phase 2: migrate recent content

Load CSV status, when "Using Periodic Commit"

smtatman
Node

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.

smtatman
Node

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.