Yes, it's loaded correctly. Also the values are strings, already checked
that.
Here is a one more workaround:
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file://path/to/file.csv" AS relation
MATCH (user:User {id: relation.user_id})-[likes:LIKES]->(shop:Shop {id:
relation.shop_id})
return count(likes)
This query takes about 800-900 seconds as well. I believe the previous
query is slow of the same reason - slow matching of the existing
relationship. Is that possible to improve the performance here, or it's
just the way Neo4j works?
On Friday, March 20, 2015 at 12:43:04 PM UTC+2, Michael Hunger wrote:
>
> 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]
> <javascript:>>:
> >
> > 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] <javascript:>.
> > 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.
