csv - SyntaxException with Neo4j LOAD command -
i'm using neo4j 2.1.2 windows attempting utilize neo4j's load csv command next error...
neo4j-sh (?)$ load csv headers "file:../test/unclaimed.csv" csvline merge (o:original_transaction_number { value: csvline.otn }) merge (i:institution {name: csvline.institution }) merge (i)<-[:transaction_of]-(o) ; syntaxexception: invalid input 'l': expected <init> (line 1, column 1) "load csv headers "file:../test/unclaimed.csv" csvline" ^
infact same error entering load
neo4j-sh (?)$ load ; ==> syntaxexception: invalid input 'l': expected <init> (line 1, column 1) ==> "load " ==> ^
could explain what's happening?
(edit:)->(fixed)->(the problem)
combination of issues here.
i had before tried upgrading 2.1.2 extracting files 2.0.3 folder - fixed - @stefan
fixing 1. , prefixing "cypher 2.1" (thanks @michael) gave more informative error "syntaxexception: invalid input '"': expected whitespace, comment or (line 1, column 23) - i missing keyword
after getting many "loadexternalresourceexception: couldn't load external resource at: file:../test/unclaimed.csv" , many variants of "file://c:/nosql/test/" etc i finally figured syntax accessing local file on windows "file:c:/nosql/test/unclaimed.csv" , not file:// might inferred examples on http://neo4j.com/docs/2.1.2/cypherdoc-importing-csv-files-with-cypher/ or familiar uri schema
thanks folks
csv neo4j load uri filenames
No comments:
Post a Comment