ISSUE Update Node Property Key on large data

[pratik_sonawane]

I have 100gb of data in graphdb,iwant to update porperty key of node.
I used below cypher its taking to much time and failed.

match (ele:Element) SET ele.NEW_PORP_KEY=ele.OLD_PORP_KEY REMOVE ele.OLD_PROP_KEY return ele;

[david_allen]

If you have a very large amount of data, the transaction you're doing to update that much may be blowing up your available heap space.

One possibility would be to give your server a lot more RAM. The other would be to break down your transaction into batches of smaller numbers, so that each smaller transaction fits into your available memory.

To batch your transactions, you can use apoc.periodic.iterate:

http://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/cypher-execution/commit-batching/