Hello , i iam trying to update my node properties by "USING periodic commit" in neo4j database 4.1.3.
USING PERIODIC COMMIT 1000 LOAD CSV WITH HEADERS FROM "file:///pref_score.csv" as line MATCH(n:CUSTOMER) WHERE n.IDENTITYID=line.IDENTITYID SET n.PA_SCORE=line.pa_score
this worked well in previous 3.5.8 version. the query throws
Neo.ClientError.Statement.SemanticError Executing queries that use periodic commit in an open transaction is not possible.
I tried to use this query with auto but it took so long time but didn't update anything but my browser has PA_SCORE property. My neo4j desktop version is 1.3.8 and the browser version is 4.1.2
is there any alternative way to fix this . Kindly help me