Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enhance ScanVertices/ScanEdges and some index selecting logics #4313

Closed
czpmango opened this issue Jun 9, 2022 · 2 comments
Closed

Enhance ScanVertices/ScanEdges and some index selecting logics #4313

czpmango opened this issue Jun 9, 2022 · 2 comments
Labels
type/enhancement Type: make the code neat or more efficient

Comments

@czpmango
Copy link
Contributor

czpmango commented Jun 9, 2022

Degenerates to ScanVertices/ScanEdges only if no index exists. In other words, there will be IndexScan on the execution plan as long as there is an index available.(Fix Query1 and refactor the plan of Query2)

Query3 will prefer the node index(eg. index of player or team) over the edge index(index of serve).

// Query1
(root@nebula) [nba]> match (v:player:team) return v
[ERROR (-1005)]: Scan vertices or edges need to specify a limit number, or limit number can not push down.

// Query2
(root@nebula) [nba]> match (v:player:team) return v limit 3
+---+
| v |
+---+
+---+
Empty set (time spent 5721/6029 us)

// Query3
(root@nebula) [nba]> match (v:player:team)-[:serve]->(n) return v
+---+
| v |
+---+
+---+
Empty set (time spent 11076/11383 us)

@czpmango czpmango added the type/enhancement Type: make the code neat or more efficient label Jun 9, 2022
@czpmango
Copy link
Contributor Author

czpmango commented Jun 9, 2022

This error([ERROR (-1005)]: Scan vertices or edges need to specify a limit number, or limit number can not push down.) will only be raised when no available index and no limit clause.

@czpmango
Copy link
Contributor Author

Closed because retesting the above behavior is expected.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement Type: make the code neat or more efficient
Projects
None yet
Development

No branches or pull requests

2 participants