apoc icon indicating copy to clipboard operation
apoc copied to clipboard

feature request: return data from apoc.periodic.commit

Open neo-technology-build-agent opened this issue 2 years ago • 0 comments

Issue by tbrantb Monday May 21, 2018 at 12:56 GMT Originally opened as https://github.com/neo4j-contrib/neo4j-apoc-procedures/issues/812


On occasion I use periodic.commit to perform some kind of large migration. (delete data, move relationships, create inferred data, etc). I'd like a way to also output data from the query run from periodic commit. For example if I'm deleting data, I'd like to return certain properties about what I'm deleting, or if I'm creating data return attributes of the newly created structures. The RETURN statement is a natural way to do this outside periodic.commit where I can take the output and use/store as verification, validation, auditing. Unfortunately for periodic.commit to work, the RETURN statement must be leveraged to return an integer eventually ending at 0. Another possibility would be some kind of defined output to a file (csv or other) as periodic commit executes.