Hi All,
I am trying to create a new node based on the common property found in the existing nodes. Say for example, I have two nodes Car1 and Car2. Both have the same property color:'blue'. Now I want to create a new node called Color and create a relationship between the Cars and the Color.
I am running the below query to achieve the same but I getting the memory error.
MATCH (n:Car)
UNWIND n.color AS color
WITH color, collect(n) AS cars
MERGE (c:Color {car_color:color})
WITH c, cars
UNWIND cars AS n
WITH c,n
MERGE (n)-[:GROUP_TYPE]->(c);
But as I have 10k nodes, running this command is throwing the memory error.
'The allocation of an extra 273.2 MiB would use more than the limit 250.0 MiB. Currently using 2.8 MiB. dbms.memory.transaction.global_max_size threshold reached'
Can someone help me optimize the query. Thanks a lot