Skip to content

Instantly share code, notes, and snippets.

@LeonardoMarrancone

LeonardoMarrancone/queryCategory.cql

Last active July 14, 2020 15:40
Show Gist options
  • Save LeonardoMarrancone/73f53b44f351379f59a0f78a044cd858 to your computer and use it in GitHub Desktop.
Save LeonardoMarrancone/73f53b44f351379f59a0f78a044cd858 to your computer and use it in GitHub Desktop.
Download ZIP
Query to import Category
Raw
queryCategory.cql
LOAD CSV FROM 'file:///shows.csv' AS row
WITH row, toInteger(row[0]) as id, row[1] as labels, row[2] as follows, row[3] as name, row[4] as surname, toInteger(row[5]) as start, toInteger(row[6]) as end, row[7] as type, toFloat(row[8]) as rating
WHERE labels=":Category"
CREATE (:Category{id:id, name: name})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment