Remove the space before shop_id try to run:
LOAD CSV WITH HEADERS FROM "file:test.csv" AS r return r.user_id, r.shop_id limit 10; to see if it is loaded correctly Also make sure that you didn't store the id's as numeric values in the first place, then you have to use toInt(r.shop_id) M > Am 19.03.2015 um 13:43 schrieb Eugene C. <[email protected]>: > > Hey everyone, > > I have some issues importing a set of relationships from a CSV file. > > I'm running Neo4j 2.1.7 under Mac OSX (10.9.5), 16GB RAM. > > The file has the following schema: > > user_id, shop_id > 1,230 > 1,458 > 1,783 > 2,942 > 2,123 > etc. > > It contains about 2M records (relationships). > > Here is the query I'm running using the browser UI (I was also trying to do > the same with a REST call): > USING PERIODIC COMMIT > LOAD CSV WITH HEADERS FROM "file://path/to/my/file.csv" AS relation > MATCH (user:User {id: relation.user_id}) > MATCH (shop:Shop {id: relation.shop_id}) > MERGE (user)-[:LIKES]->(shop) > > This query takes ages to run, about 800 seconds. I do have indexes on > :User(id) and :Shop(id). Created them with: > CREATE INDEX ON :User(id) > CREATE INDEX ON :Shop(id) > > Any ideas on how to increase the performance? > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
