Neo4j and Cypher: Create relationships to nodes that have similar property keys

Question

Given the following nodes:

create(:ABC{id:'1', a:'axle',b:'bat'})
create(:ABC{id:'2', a:'ant',b:'ball',c:'clown'})
create(:ABC{id:'3', e:'elk',f:'fog',g:'gaff'})
create(:ABC{id:'4', a:'ax',c:'car',z:'zink'})

Using cypher, how would one create edges between nodes that share 1 or more property keys (regardless of their property value and with an unknown set of properties)? I'm fairly certain I could iterate thru nodes individually via python and create edges, but I have tried without success to do this in cypher.

cybersam cybersam · Accepted Answer · 2015-08-07T04:33:02

Here is a query that creates a SHARES_KEYS_WITH relationship between every pair of nodes that share at least one property with the same name (ignoring the id property, which all your example nodes have).

MATCH (m),(n)
WHERE (ID(m) > ID(n)) AND ANY (k IN KEYS(m) 
                              WHERE k <> 'id' AND k IN KEYS(n))
CREATE (m)-[:SHARES_KEYS_WITH]->(n)
RETURN m, n;

The ID(m) > ID(n) test ensures that we only evaluate each pair of distinct nodes just once. (Note that the ID() function returns the neo4j-generated internal identifier -- with is not the same as your id property.)

Neo4j and Cypher: Create relationships to nodes that have similar property keys

1 Answers