Hi Axel, As the Cypher script action allows you to execute multiple scripts separated by a semicolon the code contains an explicit transaction and commits after all commands are executed successfully.
I added a ticket [1] to investigate if we can add an option to avoid this and allow PERIODIC COMMIT queries. Unfortunately, I do not know of an alternative way to handle this query now but maybe someone else on the mailing list has a creative solution. Cheers, Hans [1] https://issues.apache.org/jira/browse/HOP-4033 On Thu, 30 Jun 2022 at 14:37, Kachler, Axel <[email protected]> wrote: > Dear Apache Hop Team, > > > > I’d like to run the following implicit transaction in the Cypher Action > <https://hop.apache.org/manual/latest/pipeline/transforms/neo4j-cypher.html> > : > > > > :auto MATCH (n:test) > > CALL { WITH n > > DETACH DELETE n > > } IN TRANSACTIONS OF 10000 ROWS; > > > > But the following error notification appears: > > > > Do you know what I can do that Hop accepts a statement which starts with a > “:”. > > Maybe it’s a problem with my driver. > > > > Thank you for your support. > > Kind regards > > > > Axel > > > > > > Mit freundlichen Grüßen > > Axel Kacher > > > > Siemens AG > > Global Business Services > > Business Solutions & Services > > Data Process Consulting > > GBS B&S DE SOL GMS DCS DPC > > Dynamostr. 4 > > 68165 Mannheim, Deutschland > > mailto:[email protected] <[email protected]> > > www.siemens.com > > [image: Logo] > > > > > > >
