CODEWITHSUNDEEP
neo4jcypher
Jeevanantham
Jeevanantham

Reputation: 1022

Cypher query, Load CSV not responding in Neo4j 2.1

While try to upload the data to Neo4j 2.1 through LOAD CSV command, its not responding and even doesn't throw any exception while try with invalid path. Any comments

LOAD CSV FROM "file:///d:/import.csv" AS csvLine
MERGE (p:Person { name: csvLine[0]})
MERGE (m:Movie { title: csvLine[1]})  
CREATE (p)-[:PLAYED { role: csvLine[2]}]->(m)

enter image description here

Upvotes: 3

Views: 1654

Answers (2)

user4275237
user4275237

Reputation: 1

When loading on Windows user file:C:/whatever (note no // or /// forward slahes after the 'file' protocol...

http://www.neo4j.org/graphgist?d788e117129c3730a042

Upvotes: 0

Kenny Bastani
Kenny Bastani

Reputation: 3308

Sorry to hear you're having issues. Please refresh the browser's cache to use the LOAD CSV statement.

This is a bug in the milestone release. I've opened an issue on GitHub: https://github.com/neo4j/neo4j/issues/2215

When upgrading Neo4j 2.0.1 to 2.1.0-M01 the JS file containing the client-side validation for Cypher is returning as a cached version of the previous release. Because of this, users trying to use the LOAD CSV feature by either start word "LOAD" or "USING" will receive a red alert that says ":help". To prevent this issue, the reference URI of the JS files should contain a query string key-value pair "...?version=2.1.0-M06" or the file name should be changed for each release to include the release version.

Current work-around: Refresh your browser cache for the page (CTRL+F5 on Windows, SHIFT+F5 on Mac OSX).

Upvotes: 1

Related Questions