Skip to content

Instantly share code, notes, and snippets.

@daemonfire300

daemonfire300/import.cql

Created June 9, 2016 09:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save daemonfire300/ac563d2f732ffc4954a27a344fc7a1fa to your computer and use it in GitHub Desktop.
Save daemonfire300/ac563d2f732ffc4954a27a344fc7a1fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
import.cql
CREATE CONSTRAINT ON (l:Location) ASSERT l.locationid IS UNIQUE;
CREATE INDEX ON :Location(locationid);
USING PERIODIC COMMIT 5000
LOAD CSV WITH HEADERS FROM 'file:///wln_label-type.txt.csv' AS line WITH line
MERGE (location:Location {locationid: toInt(line.locationid)} )
RETURN COUNT(location);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment