Hi,
I am running into memory issues while running:
MATCH (a:alias)-[rel]-(:alias)
WITH collect(DISTINCT a) AS Alias, collect(rel) AS related_to
CALL apoc.export.csv.data(Alias, related_to, "ALIAS_ALIAS.csv",{})
YIELD file, source, format, nodes, relationships, properties, time, rows, batchSize, batches, done, data
RETURN file, source, format, nodes, relationships, properties, time, rows, batchSize, batches, done, data
Neo.TransientError.General.OutOfMemoryError: There is not enough memory to perform the current task. Please try increasing 'dbms.memory.heap.max_size' in the neo4j configuration (normally in 'conf/neo4j.conf' or, if you you are using Neo4j Desktop, found through the user interface) or if you are running an embedded installation increase the heap by using '-Xmx' command line flag, and then restart the database.
When I use another apoc procedure on top of this export
CALL apoc.periodic.iterate(
"MATCH (a:alias)-[rel]-(:alias)
RETURN collect(DISTINCT a) AS Alias, collect(rel) AS related_to",
"CALL apoc.export.csv.data(Alias, related_to, "ALIAS_ALIAS.csv",{})
YIELD file, source, format, nodes, relationships, properties, time, rows, batchSize, batches, done, data",
{batchSize:5000})
YIELD batches, total, errorMessages
I get syntax issues. How can I work around these and successfully export?
Thanks