Find duplicated property in Neo4j

Posted by itungnt on Monday, January 25, 2016

Today I got a critical problem with the duplicated property in Neo4j. We index that property to query for the node, and it is duplicated then give us the wrong node.

Below is the Cypher use to find which node and which value of that property duplicated and how many time

I found that Neo4j also support unique constraint but in Enterprise Edition only.

Neo4j helps enforce data integrity with the use of constraints. Constraints can be applied to either nodes or relationships. Unique node property constraints can be created, as well as node and relationship property existence constraints.

Property existence constraints are only available in the Neo4j Enterprise Edition. Note that databases with property existence constraints cannot be opened using Neo4j Community Edition.


comments powered by Disqus