mneedham
commented
6 years ago Can you check how many records are returned by the node and relationship projection queries? If you replace the last lines with:
Return count (*)
That should do it
On Mon, Jun 11, 2018, 17:49 Anirudh Alampally notifications@github.com wrote:
I am getting a weird error when using shortestPath algorithms in graph-algorithms. In the graph data I have Person node with primaryEmail as once of the attributes. This contains emails of multiple domains. e.g., a@xyz.com, x@abc.com etc..
When I run the following query MATCH (source:Person{primaryEmail:'a@xyz.com'}), ( target:Person{primaryEmail:'b@xyz.com'}) CALL algo.shortestPath.stream(source, target, "cost",{ nodeQuery:'MATCH(n:Person) RETURN id(n) as id', relationshipQuery:'MATCH(n:Person)-[r:connected_to]-(m:Person) RETURN id(n) as source, id(m) as target, (1.0/(r.weight+1.0)) as weight', graph:'cypher'}) YIELD nodeId, cost MATCH (other:Person) WHERE id(other) = nodeId RETURN other.name, cost
It is giving me the following error: Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure 'algo.shortestPath.stream': Caused by: java.lang.ArrayIndexOutOfBoundsException: -1073739909
Just as a tweak, I tried to limit the nodes to a particular domain of email and it started running.The updated query is: MATCH (source:Person{primaryEmail:'a@xyz.com'}), ( target:Person{primaryEmail:'b@xyz.com'}) CALL algo.shortestPath.stream(source, target, "cost",{ nodeQuery:'MATCH(n:Person) where n.primaryEmail ends with @xyz.com RETURN id(n) as id', relationshipQuery:'MATCH(n:Person)-[r:connected_to]-(m:Person) RETURN id(n) as source, id(m) as target, (1.0/(r.weight+1.0)) as weight', graph:'cypher'}) YIELD nodeId, cost MATCH (other:Person) WHERE id(other) = nodeId RETURN other.name, cost
Is the error because the virtual graph which is created by filtering the relationships, creating a graph which is very big and exceeding the memory? Any help is much appreciated!!
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/neo4j-contrib/neo4j-graph-algorithms/issues/659, or mute the thread https://github.com/notifications/unsubscribe-auth/AAAzpMqtc1g9I203SV0rDQP8rTzXyB9kks5t7p-lgaJpZM4UjCiG .
aalampally
I am getting a weird error when using shortestPath algorithms in
graph-algorithms. In the graph data I have Person node with primaryEmail as once of the attributes. This contains emails of multiple domains. e.g., a@xyz.com, x@abc.com etc..When I run the following query
MATCH (source:Person{primaryEmail:'a@xyz.com'}), (target:Person{primaryEmail:'b@xyz.com'}) CALL algo.shortestPath.stream(source, target, "cost",{ nodeQuery:'MATCH(n:Person) RETURN id(n) as id', relationshipQuery:'MATCH(n:Person)-[r:connected_to]-(m:Person) RETURN id(n) as source, id(m) as target, (1.0/(r.weight+1.0)) as weight', graph:'cypher'}) YIELD nodeId, cost MATCH (other:Person) WHERE id(other) = nodeId RETURN other.name, costIt is giving me the following error:
Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure 'algo.shortestPath.stream': Caused by: java.lang.ArrayIndexOutOfBoundsException: -1073739909Just as a tweak, I tried to limit the nodes to a particular domain of email and it started running.The updated query is:
MATCH (source:Person{primaryEmail:'a@xyz.com'}), (target:Person{primaryEmail:'b@xyz.com'}) CALL algo.shortestPath.stream(source, target, "cost",{ nodeQuery:'MATCH(n:Person) where n.primaryEmail ends with @xyz.com RETURN id(n) as id', relationshipQuery:'MATCH(n:Person)-[r:connected_to]-(m:Person) RETURN id(n) as source, id(m) as target, (1.0/(r.weight+1.0)) as weight', graph:'cypher'}) YIELD nodeId, cost MATCH (other:Person) WHERE id(other) = nodeId RETURN other.name, costIs the error because the virtual graph which is created by filtering the relationships, creating a graph which is very big and exceeding the memory? Any help is much appreciated!!