Advertisement
Guest User

Untitled

a guest
Jul 15th, 2014
236
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.12 KB | None | 0 0
  1. MATCH
  2. (:PersonType {name: "Cool Guys"})<-[:OF_TYPE]-(p:Person)-[:EXPRESSES]->(o),
  3. opath=(o)-[:REFERENCES*0..]->(op:Opinion)
  4. MATCH (x)<-[:EXPRESSES]-(opAuthor:Person)
  5. WHERE x IN nodes(opath)
  6. RETURN p.name AS person, op AS opinion, collect(opAuthor) AS influence
  7.  
  8. ==> ColumnFilter
  9. ==> |
  10. ==> +EagerAggregation
  11. ==> |
  12. ==> +Extract
  13. ==> |
  14. ==> +Filter(0)
  15. ==> |
  16. ==> +SimplePatternMatcher
  17. ==> |
  18. ==> +NodeByLabel
  19. ==> |
  20. ==> +ExtractPath
  21. ==> |
  22. ==> +Filter(1)
  23. ==> |
  24. ==> +TraversalMatcher
  25. ==>
  26. ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
  27. ==> | Operator | Rows | DbHits | Identifiers | Other |
  28. ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
  29. ==> | ColumnFilter | 98 | 0 | | keep columns person, opinion, influence |
  30. ==> | EagerAggregation | 98 | 0 | | person, opinion |
  31. ==> | Extract | 105 | 210 | | person, opinion |
  32. ==> | Filter(0) | 105 | 0 | | any(-_-INNER-_- in NodesFunction(opath) where x == -_-INNER-_-) |
  33. ==> | SimplePatternMatcher | 105 | 0 | opAuthor, x, UNNAMED143 | |
  34. ==> | NodeByLabel | 269892 | 269990 | opAuthor, opAuthor | :Person |
  35. ==> | ExtractPath | 98 | 0 | opath | |
  36. ==> | Filter(1) | 98 | 105 | | (hasLabel(op:Opinion(9)) AND NOT( UNNAMED44 == UNNAMED67)) |
  37. ==> | TraversalMatcher | 105 | 424 | | op, UNNAMED101, op, UNNAMED67, op, UNNAMED44, op |
  38. ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
  39.  
  40.  
  41. MATCH
  42. (:PersonType {name: "Cool Guys"})<-[:OF_TYPE]-(p:Person)-[:EXPRESSES]->(o),
  43. opath=(o)-[:REFERENCES*0..]->(op:Opinion)
  44. WITH opath,p,op
  45. MATCH (x)<-[:EXPRESSES]-(opAuthor:Person)
  46. WHERE x IN nodes(opath)
  47. RETURN p.name AS person, op AS opinion, collect(opAuthor) AS influence
  48.  
  49. ==> ColumnFilter(0)
  50. ==> |
  51. ==> +EagerAggregation
  52. ==> |
  53. ==> +Extract
  54. ==> |
  55. ==> +Filter(0)
  56. ==> |
  57. ==> +SimplePatternMatcher
  58. ==> |
  59. ==> +NodeByLabel
  60. ==> |
  61. ==> +ColumnFilter(1)
  62. ==> |
  63. ==> +ExtractPath
  64. ==> |
  65. ==> +Filter(1)
  66. ==> |
  67. ==> +TraversalMatcher
  68. ==>
  69. ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
  70. ==> | Operator | Rows | DbHits | Identifiers | Other |
  71. ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
  72. ==> | ColumnFilter(0) | 98 | 0 | | keep columns person, opinion, influence |
  73. ==> | EagerAggregation | 98 | 0 | | person, opinion |
  74. ==> | Extract | 105 | 210 | | person, opinion |
  75. ==> | Filter(0) | 105 | 0 | | any(-_-INNER-_- in NodesFunction(opath) where x == -_-INNER-_-) |
  76. ==> | SimplePatternMatcher | 105 | 0 | opAuthor, x, UNNAMED159 | |
  77. ==> | NodeByLabel | 269892 | 269990 | opAuthor, opAuthor | :Person |
  78. ==> | ColumnFilter(1) | 98 | 0 | | keep columns opath, p, op |
  79. ==> | ExtractPath | 98 | 0 | opath | |
  80. ==> | Filter(1) | 98 | 105 | | (hasLabel(op:Opinion(9)) AND NOT( UNNAMED44 == UNNAMED67)) |
  81. ==> | TraversalMatcher | 105 | 424 | | op, UNNAMED101, op, UNNAMED67, op, UNNAMED44, op |
  82. ==> +----------------------+--------+--------+---------------------------+-----------------------------------------------------------------+
  83. ==>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement