Hi thanks for your answer,
But din't understand, what are you trying to say. The thing I am trying to
say, might not be built on console.neo4j.org or rather
neo4j-console-19.herokuapp.com
<http://www.google.com/url?q=http%3A%2F%2Fneo4j-console-19.herokuapp.com&sa=D&sntz=1&usg=AFQjCNG8fyshX6XdC2Izysfc5PnC62n-Zg>
....Or
may be I do not know how to do that indexing. What did you mean by second
index Lookup? I hope you are not implying about the filters. here *r.name *is
the relationship name(Property of relation). I am not sure, why I skipped
the *DISTINCT* part on count, but thanks.
So the question remains, Have anyone found anything with the indexer?
*Hunger*, could you please give an example, how can I skip the multiple
index lookup [Not changing the design :D]?
Thanks....
Thanks a ton *Hunger*....
I hope I get an answer.... :D
On Tuesday, 10 June 2014 23:02:22 UTC+5:30, Michael Hunger wrote:
>
> I think you don't need the second index lookup.
> It will faster to just let the matcher do it's job.
>
> It will only aggregate on n.UID, r.name
> (don't know what r.name is)
>
> please note that count(*) counts the total rows generated by the matcher,
> not the distinct data elements.
>
> you probably want to use count(distinct u.UUID)
>
> Michael
>
> START n=node:NODE("(UUID:1 OR UUID:2 OR UUID:3 OR UUID:4 OR UUID:5) AND
> 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
>
>
> Am 14.05.2014 um 13:33 schrieb Biswajit Kumar Das <[email protected]
> <javascript:>>:
>
> 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] <javascript:>.
> For more options, visit 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.