Hester-Gu
commented
1 year ago (root@nebula) [nba]> profile match ()-[e]->() return e skip 1 limit 10
+---------------------------------------------------------------------------+
| e |
+---------------------------------------------------------------------------+
| [:like "Dwyane Wade"->"Chris Paul" @0 {likeness: 90}] |
| [:like "Dwyane Wade"->"LeBron James" @0 {likeness: 90}] |
| [:serve "Dwyane Wade"->"Bulls" @0 {end_year: 2017, start_year: 2016}] |
| [:serve "Dwyane Wade"->"Cavaliers" @0 {end_year: 2018, start_year: 2017}] |
| [:serve "Dwyane Wade"->"Heat" @0 {end_year: 2016, start_year: 2003}] |
| [:serve "Dwyane Wade"->"Heat" @1 {end_year: 2019, start_year: 2018}] |
| [:like "Tony Parker"->"LaMarcus Aldridge" @0 {likeness: 90}] |
| [:like "Tony Parker"->"Manu Ginobili" @0 {likeness: 95}] |
| [:like "Tony Parker"->"Tim Duncan" @0 {likeness: 95}] |
+---------------------------------------------------------------------------+
Got 9 rows (time spent 2019/3462 us)
Execution Plan (optimize time 277 us)
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| id | name | dependencies | profiling data | operator info |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| 13 | Project | 18 | ver: 0, rows: 9, execTime: 8us, totalTime: 8us | outputVar: { |
| | | | | "colNames": [ |
| | | | | "e" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Limit_8" |
| | | | | } |
| | | | | inputVar: __Limit_14 |
| | | | | columns: [ |
| | | | | "$-.e[0] AS e" |
| | | | | ] |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| 18 | Limit | 19 | ver: 0, rows: 9, execTime: 3us, totalTime: 4us | outputVar: { |
| | | | | "colNames": [ |
| | | | | "__VAR_0", |
| | | | | "e", |
| | | | | "__VAR_1" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Limit_14" |
| | | | | } |
| | | | | inputVar: __AppendVertices_19 |
| | | | | offset: 1 |
| | | | | count: 10 |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| 19 | AppendVertices | 17 | { | outputVar: { |
| | | | ver: 0, rows: 10, execTime: 122us, totalTime: 420us | "colNames": [ |
| | | | resp[0]: { | "e", |
| | | | "exec": "86(us)", | "__VAR_1" |
| | | | "host": "storage-0.storage:9779", | ], |
| | | | "total": "303(us)" | "type": "DATASET", |
| | | | } | "name": "__AppendVertices_19" |
| | | | total_rpc: 352(us) | } |
| | | | } | inputVar: __Project_17 |
| | | | | space: 4 |
| | | | | dedup: true |
| | | | | limit: 11 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | src: none_direct_dst($-.e) |
| | | | | props: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 5 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 7 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 6 |
| | | | | } |
| | | | | ] |
| | | | | exprs: |
| | | | | vertex_filter: |
| | | | | if_track_previous_path: true |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| 17 | Project | 16 | ver: 0, rows: 10, execTime: 37us, totalTime: 38us | outputVar: { |
| | | | | "colNames": [ |
| | | | | "e" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_17" |
| | | | | } |
| | | | | inputVar: __ScanEdges_16 |
| | | | | columns: [ |
| | | | | "[EDGE] AS e" |
| | | | | ] |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| 16 | ScanEdges | 3 | { | outputVar: { |
| | | | ver: 0, rows: 10, execTime: 171us, totalTime: 927us | "colNames": [ |
| | | | resp[0]: { | "e" |
| | | | "exec": "478(us)", | ], |
| | | | "host": "storage-0.storage:9779", | "type": "DATASET", |
| | | | "total": "815(us)" | "name": "__ScanEdges_16" |
| | | | } | } |
| | | | total_rpc: 884(us) | inputVar: |
| | | | } | space: 4 |
| | | | | dedup: true |
| | | | | limit: 10 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | props: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_src", |
| | | | | "_type", |
| | | | | "_rank", |
| | | | | "_dst", |
| | | | | "start_year", |
| | | | | "end_year" |
| | | | | ], |
| | | | | "type": 10 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_src", |
| | | | | "_type", |
| | | | | "_rank", |
| | | | | "_dst", |
| | | | | "likeness" |
| | | | | ], |
| | | | | "type": 8 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_src", |
| | | | | "_type", |
| | | | | "_rank", |
| | | | | "_dst", |
| | | | | "start_year", |
| | | | | "end_year" |
| | | | | ], |
| | | | | "type": 9 |
| | | | | } |
| | | | | ] |
| | | | | exprs: |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
| 3 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 9us | outputVar: { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Start_3" |
| | | | | } |
-----+----------------+--------------+-----------------------------------------------------+----------------------------------
Fri, 13 Jan 2023 09:17:28 UTC
Shylock-Hg
Please check the FAQ documentation before raising an issue
Describe the bug (required) First of all, there is no problem using limit in match. But when limit and skip are used at the same time, the returned data is limited first and then skipped. I think the returned data should be skip first and then limit.
I should return 10 rows of data except the first one instead of 9 rows.
Your Environments (required)
nebula: v3.3
How To Reproduce(required)
Steps to reproduce the behavior:
Expected behavior
Additional context