the query looks ok to me. do you have any memory constraints on your server?
could you by chance share your original graph? Thanks Michael > Am 04.07.2015 um 23:59 schrieb Markus Hofer <[email protected]>: > > The following query works, inserting 5000 nodes and relationships in 3 seconds > > MATCH > (n:Contact)--(:ActivityContact)--(ar:ActivityReport)--(:ActivityContact)--(nn:Contact) > WHERE n <> nn > WITH DISTINCT n, COUNT(ar) AS value > CREATE (s:ScoreFactor { > name: "MeetingContactFrequency1", > rawvalue: value > }) > CREATE (n)-[:HasScoreFactor]->(s) > > For some reason this query does not work. Although it matches 11000 distinct > (n), it runs endlessly without creating any nodes. Server load is 100%. > > MATCH > (n:Contact)--(:ActivityContact)--(ar:ActivityReport)--(:ActivityUser)--(:User) > WITH DISTINCT n, COUNT(ar) AS value > CREATE (s:ScoreFactor { > name: "MeetingContactFrequency2", > rawvalue: value > }) > CREATE (n)-[:HasScoreFactor]->(s) > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
