Getting "Invalid input ':': expected <init> )" on terminal but not on browser

[mosheco]

Issuing the statement

:auto USING PERIODIC COMMIT 500
LOAD CSV ...

in the Neo4j terminal, ends up with

Invalid input ':': expected <init> (line 1, column 1 (offset: 0))

Doing the same on the Neo4j browser, works with no problem.

[glilienfield · Accepted solution]

"using periodic commit" and "call in transactions" use implicit transactions.

Section 7: https://neo4j.com/docs/cypher-manual/current/clauses/load-csv/#load-csv-setting-the-rate-of-periodic...

These require the ':auto" prefix in neo4j browser. I don't think cypher-shell supports implicit transactions. The documentation states cypher-shell supports explicit transactions, which means they have to be managed in the code. See section 8 in below reference. 

https://neo4j.com/docs/operations-manual/current/tools/cypher-shell/

Maybe look into using the apoc periodic procedures, such as commit, when using cypher-shell.