USING PERIODIC COMMIT
LOAD CSV FROM 'file:///file1' AS line
MERGE (n:User { name: line[0] })
MERGE (m:User { name: line[2] })
CREATE (n)-[:hashtag{ name: line[1]}]->(m)
create (n:User{id:'first',x:TRUE,y:TRUE,a:0,b:0}) return n
USING PERIODIC COMMIT
LOAD CSV FROM 'file:///file2' AS line
Match (k:User) where
k.id='first'
MERGE (n:User { name: line[0] }) on create set k.x=FALSE on match set k.x=TRUE
MERGE (m:User { name: line[2] }) on create set k.y=FALSE on match set k.y=TRUE
CREATE (n)-[:hashtag{ name: line[1]}]->(m)
Set k.b = CASE (k.x OR k.y) when TRUE THEN k.b + 1 ELSE k.b END
Set k.a = CASE (k.x XOR k.y) when TRUE THEN k.a + 1 ELSE k.a END
Is there something wrong with this code?
Because it is not working properly.