Getting error:Executing queries that use periodic commit in an open transaction is not possible by "USING periodic commit" in 4.1.3 neo4j

[kalyan_b_aninda]

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

[andrew_bowman · Accepted solution]

Prefixing with :auto in the browser should be the way to go.

You'll want an index on :CUSTOMER(IDENTITYID) for this to be fast, otherwise it will be using a label scan per row, which absolutely won't work when you have a large number of :CUSTOMER nodes.