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 15:11:54 UTC+2, ducky wrote: 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) 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, with 10 rels per node this will be 100k ops, with 100 - 1M ops. Michael Am 17.06.2014 um 15:05 schrieb ducky rohit.a...@gmail.com: Hi, I am using Neo4j 2.1.2 and when I try to run the example given by Michael Hunger here http://jexp.de/blog/2014/02/cleaning-out-your-graph/: Query: USING PERIODIC COMMIT MATCH (a) OPTIONAL MATCH (a)-[r]-() DELETE a,r; Error: Neo.ClientError.Statement.InvalidSyntax Invalid input 'M': expected whitespace, comment, an integer or LoadCSVQuery (line 2, column 1) MATCH (a) My question is: has the use of this command changed since this blog post? cheers -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
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, l...@mapegy.com wrote: 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 15:11:54 UTC+2, ducky wrote: 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) 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, with 10 rels per node this will be 100k ops, with 100 - 1M ops. Michael Am 17.06.2014 um 15:05 schrieb ducky rohit.a...@gmail.com: Hi, I am using Neo4j 2.1.2 and when I try to run the example given by Michael Hunger here http://jexp.de/blog/2014/02/cleaning-out-your-graph/: Query: USING PERIODIC COMMIT MATCH (a) OPTIONAL MATCH (a)-[r]-() DELETE a,r; Error: Neo.ClientError.Statement.InvalidSyntax Invalid input 'M': expected whitespace, comment, an integer or LoadCSVQuery (line 2, column 1) MATCH (a) My question is: has the use of this command changed since this blog post? cheers -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
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) 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, with 10 rels per node this will be 100k ops, with 100 - 1M ops. Michael Am 17.06.2014 um 15:05 schrieb ducky rohit.a...@gmail.com javascript:: Hi, I am using Neo4j 2.1.2 and when I try to run the example given by Michael Hunger here http://jexp.de/blog/2014/02/cleaning-out-your-graph/: Query: USING PERIODIC COMMIT MATCH (a) OPTIONAL MATCH (a)-[r]-() DELETE a,r; Error: Neo.ClientError.Statement.InvalidSyntax Invalid input 'M': expected whitespace, comment, an integer or LoadCSVQuery (line 2, column 1) MATCH (a) My question is: has the use of this command changed since this blog post? cheers -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com javascript:. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
