How to remove/delete duplicate nodes from RedisGraph

Question

Can someone help me on deleting duplicate nodes from the RedisGraph for a particular label. I found cypher queries in Neo4j, but the are not supporting in Redis. Please help me on this.

I used below query, then RedisInsight thrown error

MATCH (p:Person)
WITH p.id as id , collect(p) AS nodes 
WHERE size(nodes) >  1
RETURN [ n in nodes | n.id ] AS ids, size(nodes)
ORDER BY size(nodes) DESC

Error: RedisGraph does not currently support list comprehension

score 4 · Accepted Answer · answered Jun 15 '20 at 08:50

4

To delete duplicates you can use the following

MATCH (p:Person)
WITH p.id as id, collect(p) AS nodes 
WHERE size(nodes) >  1
UNWIND nodes[1..] AS node
DELETE node

answered Jun 15 '20 at 08:50

SWilly22

869
4
5

Thank you so much SWilly! Above query working as expected. – Jagadeesh Urlana Jun 15 '20 at 14:06

How to remove/delete duplicate nodes from RedisGraph

1 Answers1