Bulk Update neo4j relationship properties through csv

NoobCoder 0
Viewed 19

I have a csv file which have 3 column

Follower_id,Following_id,createTime

My Node in neo4j represent a USER and it has multiple properties one of them is profileId,.Two nodes in the graph can have FOLLOW_RELATIONSHIP and i have to update the createtime for FOLLOW_RELATIONSHIP properties.There are lots of relationships in the graph. I am new in neo4j i dont have much idea about how to do bulk update efficiently.

graph-databases neo4j
1 Answers

You can try something like this:

USING PERIODIC COMMIT 1000 LOAD CSV WITH HEADERS FROM 'FILEPATH' AS row
WITH row
MATCH (u1:User{profileId: row.Follower_id})
MATCH (u2:User{profileId: row.Following_id})
MERGE (u1)-[r:FOLLOW_RELATIONSHIP]->(u2)
SET r.createTime = row.createTime

FILEPATH is the path of the file on your system, usually within the database directory itself or some web link. You can learn how to set it from this article.

Charchit Kapoor0
Related