如何从RedisGraph中移除/删除重复节点

Question

有人能帮我删除特定标签的RedisGraph中的重复节点吗？我在Neo4j中发现了cypher查询，但在Redis中不支持。请在这方面帮帮我。

我使用了下面的查询，然后RedisInsight抛出了错误

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

错误: RedisGraph当前不支持列表理解

Answer 1

要删除重复项，可以使用以下命令

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