neo4j-sh (?)$ profile 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;
+---------------------------------------+
| j1.jurt_id | j2.jurt_id | commonterms |
+---------------------------------------+
| "J70000" | "J72191" | 68 |
| "J70000" | "J73483" | 67 |
| "J70000" | "J75683" | 66 |
+---------------------------------------+
3 rows
in over 7 secs ms..
ColumnFilter(symKeys=["j1.jurt_id", "j2.jurt_id", "
INTERNAL_AGGREGATE75bdabab-2b49-42fe-9a28-4382cdb1bbf6"],
returnItemNames=["j1.jurt_id", "j2.jurt_id", "commonterms"], _rows=3,
_db_hits=0)
Top(orderBy=["SortItem(Cached(
INTERNAL_AGGREGATE75bdabab-2b49-42fe-9a28-4382cdb1bbf6 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_AGGREGATE75bdabab-2b49-42fe-9a28-4382cdb1bbf6,Count(t))"],
_rows=9992, _db_hits=0)
Extract(symKeys=["j1", "t", " UNNAMED15", " UNNAMED32", "j2"],
exprKeys=["j1.jurt_id", "j2.jurt_id"], _rows=478380, _db_hits=956760)
Filter(pred="NOT(Property(j2,jurt_id(7)) == {jurtid})", _rows=478380,
_db_hits=478380)
TraversalMatcher(start={"label": "jurt", "query": "{jurtid}",
"identifiers": ["j1"], "property": "jurt_id", "producer": "SchemaIndex"},
trail="(j1)-[ UNNAMED15:HAS_TERM WHERE true AND true]->(t)<-[
UNNAMED32:HAS_TERM WHERE NOT(Property(NodeIdentifier(),jurt_id(7)) ==
{jurtid}) AND true]-(j2)", _rows=478380, _db_hits=956967)
neo4j-sh (?)$
--
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.
