Weird, it should use the traversal matcher for the second match
How about this?
> match (j1:jurt)-[:HAS_TERM]->(t)<-[:HAS_TERM]-(j2)
> where j1.jurt_id = {jurtid} and j2.jurt_id <> {jurtid}
> return j1.jurt_id,j2.jurt_id, count(t) as commonterms
> order by commonterms desc
> limit 3
Sent from mobile device
Am 09.03.2014 um 16:50 schrieb Tom Zeppenfeldt <[email protected]>:
> profile from shell..
>
> ColumnFilter(symKeys=["j1.jurt_id", "j2.jurt_id", "
> INTERNAL_AGGREGATEd3566f14-1679-46b2-8844-2ae2b273e7b6"],
> returnItemNames=["j1.jurt_id", "j2.jurt_id", "commonterms"], _rows=3,
> _db_hits=0)
>
> Top(orderBy=["SortItem(Cached(
> INTERNAL_AGGREGATEd3566f14-1679-46b2-8844-2ae2b273e7b6 of type
> Integer),false)"], limit="Literal(3)", _rows=3, _db_hits=0)
>
> EagerAggregation(keys=["Cached(j1.jurt_id of type Any)", "Cached(j2.jurt_id
> of type Any)"], aggregates=["(
> INTERNAL_AGGREGATEd3566f14-1679-46b2-8844-2ae2b273e7b6,Count(t))"],
> _rows=9992, _db_hits=0)
>
> Extract(symKeys=["j1", "t", " UNNAMED79", "j2", " UNNAMED62"],
> exprKeys=["j1.jurt_id", "j2.jurt_id"], _rows=478380, _db_hits=956760)
>
> Filter(pred="NOT(j2 == j1)", _rows=478380, _db_hits=0)
>
> SimplePatternMatcher(g="(j1)-[' UNNAMED62']-(t),(j2)-['
> UNNAMED79']-(t)", _rows=478380, _db_hits=0)
>
> SchemaIndex(identifier="j1", _db_hits=0, _rows=1, label="jurt",
> query="{jurtid}", identifiers=["j1"], property="jurt_id",
> producer="SchemaIndex")
>
> --
> 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.
--
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.
