Re: [Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

Hi, your email format seems to be off, I can't read it. What is it you want to do? Periodic commit is now limited to LOAD CSV and can't be used outside of it anymore (since 2.1.0) Cheers, Michael On Mon, Dec 8, 2014 at 4:57 PM, wrote: > Hi, I'm trying to use the query that Michael wrote: >

Re: [Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

Hi, I'm trying to use the query that Michael wrote: MATCH (a) LIMIT 1 OPTIONAL MATCH (a)-[r]-() DELETE a,r RETURN count(*); And it doesn't work: Invalid input 'I': expected 'o/O' (line 2, column 2) "LIMIT 1" What can I do? I'm using the version 2.1.5 Fran On Tuesday, 17 June 2014 1

Re: [Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

oh, that was a really useful command when updating large datasets. +1 for this feature please. On Tuesday, 17 June 2014 14:08:08 UTC+1, Michael Hunger wrote: > > Sorry, that feature was removed between M06 and 2.1.0 :( > > So what you have to do is to run this repeatedly: > > MATCH (a) > > LIMI

[Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

Hi, I am using Neo4j 2.1.2 and when I try to run the example given by Michael Hunger here : Query: USING PERIODIC COMMIT MATCH (a) OPTIONAL MATCH (a)-[r]-() DELETE a,r; Error: Neo.ClientError.Statement.InvalidSyntax Invalid input 'M': expec

Re: [Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

Sorry, that feature was removed between M06 and 2.1.0 :( So what you have to do is to run this repeatedly: > MATCH (a) LIMIT 1 > OPTIONAL MATCH (a)-[r]-() > DELETE a,r RETURN count(*); until it returns 0. You can try higher limits though, depeding on the number of relationships per node, w