Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MATCH
- (:PersonType {name: "Cool Guys"})<-[:OF_TYPE]-(p:Person)-[:EXPRESSES]->(o),
- opath=(o)-[:REFERENCES*0..]->(op:Opinion)
- MATCH (x)<-[:EXPRESSES]-(opAuthor:Person)
- WHERE x IN nodes(opath)
- RETURN p.name AS person, op AS opinion, collect(opAuthor) AS influence
- ==> ColumnFilter
- ==> |
- ==> +EagerAggregation
- ==> |
- ==> +Extract
- ==> |
- ==> +Filter(0)
- ==> |
- ==> +SimplePatternMatcher
- ==> |
- ==> +NodeByLabel
- ==> |
- ==> +ExtractPath
- ==> |
- ==> +Filter(1)
- ==> |
- ==> +TraversalMatcher
- ==>
- ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
- ==> | Operator | Rows | DbHits | Identifiers | Other |
- ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
- ==> | ColumnFilter | 98 | 0 | | keep columns person, opinion, influence |
- ==> | EagerAggregation | 98 | 0 | | person, opinion |
- ==> | Extract | 105 | 210 | | person, opinion |
- ==> | Filter(0) | 105 | 0 | | any(-_-INNER-_- in NodesFunction(opath) where x == -_-INNER-_-) |
- ==> | SimplePatternMatcher | 105 | 0 | opAuthor, x, UNNAMED143 | |
- ==> | NodeByLabel | 269892 | 269990 | opAuthor, opAuthor | :Person |
- ==> | ExtractPath | 98 | 0 | opath | |
- ==> | Filter(1) | 98 | 105 | | (hasLabel(op:Opinion(9)) AND NOT( UNNAMED44 == UNNAMED67)) |
- ==> | TraversalMatcher | 105 | 424 | | op, UNNAMED101, op, UNNAMED67, op, UNNAMED44, op |
- ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
- MATCH
- (:PersonType {name: "Cool Guys"})<-[:OF_TYPE]-(p:Person)-[:EXPRESSES]->(o),
- opath=(o)-[:REFERENCES*0..]->(op:Opinion)
- WITH opath,p,op
- MATCH (x)<-[:EXPRESSES]-(opAuthor:Person)
- WHERE x IN nodes(opath)
- RETURN p.name AS person, op AS opinion, collect(opAuthor) AS influence
- ==> ColumnFilter(0)
- ==> |
- ==> +EagerAggregation
- ==> |
- ==> +Extract
- ==> |
- ==> +Filter(0)
- ==> |
- ==> +SimplePatternMatcher
- ==> |
- ==> +NodeByLabel
- ==> |
- ==> +ColumnFilter(1)
- ==> |
- ==> +ExtractPath
- ==> |
- ==> +Filter(1)
- ==> |
- ==> +TraversalMatcher
- ==>
- ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
- ==> | Operator | Rows | DbHits | Identifiers | Other |
- ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
- ==> | ColumnFilter(0) | 98 | 0 | | keep columns person, opinion, influence |
- ==> | EagerAggregation | 98 | 0 | | person, opinion |
- ==> | Extract | 105 | 210 | | person, opinion |
- ==> | Filter(0) | 105 | 0 | | any(-_-INNER-_- in NodesFunction(opath) where x == -_-INNER-_-) |
- ==> | SimplePatternMatcher | 105 | 0 | opAuthor, x, UNNAMED159 | |
- ==> | NodeByLabel | 269892 | 269990 | opAuthor, opAuthor | :Person |
- ==> | ColumnFilter(1) | 98 | 0 | | keep columns opath, p, op |
- ==> | ExtractPath | 98 | 0 | opath | |
- ==> | Filter(1) | 98 | 105 | | (hasLabel(op:Opinion(9)) AND NOT( UNNAMED44 == UNNAMED67)) |
- ==> | TraversalMatcher | 105 | 424 | | op, UNNAMED101, op, UNNAMED67, op, UNNAMED44, op |
- ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
- ==>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement