Some more Insight
I felt, it is a lucene related problem. Because the value I was expecting
which is getting displayed If I Choose to use below query
CORRECT
START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5 OR
UUID:6 OR UUID:8) AND OBJECTTYPE:USER"),
u=node(*)
MATCH n<-[r:FOLLOWS|KNOWS]-u
WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT u.
UUID) AS ALL
RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST
Again this is correct, I have seen if the node's are lesser than or equal
to five
CORRECT
START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4) AND
OBJECTTYPE:USER"),
u=node:NODE("OBJECTTYPE:USER")
MATCH n<-[r:FOLLOWS|KNOWS]-u
WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT u.
UUID) AS ALL
RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST
Where as below query is still coming wrong
WRONG
START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5 OR
UUID:6 OR UUID:8) AND OBJECTTYPE:USER"),
u=node:NODE("OBJECTTYPE:USER")
MATCH n<-[r:FOLLOWS|KNOWS]-u
WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT u.
UUID) AS ALL
RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST
If you think it might be an index issue, I am able to do this
CORRECT
START root=node:NODE("OBJECTTYPE:USER")
WHERE root.UUID = 7
RETURN root
This thing is making me nuts.....Any idea, where I am doing wrong?
How can I use http://www.neo4j.org/console to create Index, so that I can
make this output visible for all?
Yes I have tried this on newest version.
Regards
Biswajit
On Wednesday, 14 May 2014 17:03:48 UTC+5:30, Biswajit Kumar Das wrote:
>
> Hi
> I am not so new in Neo4J, but our Neo4J engine is old (Neo4j - Graph
> Database Kernel 1.9) We have a very simple query running as down below
> Where I am trying to find out some user's total follow and know and
> whether a specific user exist in them. Am I doing this wrong? :(
> Because it behaves differently when the relationship increases. The TOTAL
> and EXIST value starts coming wrong. I even checked out each relationship,
> whether they exists or not, they do. Sometimes relations are between the
> nodes of same set (Could this be any issue?). So I tried to decrease the
> relations and again it starts coming correct. Where I am doing wrong?
>
> Thanks in advance
>
> Regards
> Biswajit
> START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5) AND
> OBJECTTYPE:USER"),
> u=node:NODE("OBJECTTYPE:USER")
> MATCH n<-[r:FOLLOWS|KNOWS]-u
> WITH n.UUID AS UUID,r.name AS RELATION,count(*) AS TOTAL,collect(DISTINCT
> u.UUID) AS ALL
> RETURN UUID,RELATION,TOTAL,"7" IN ALL AS EXIST
>
>
--
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.
