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

LOOKUP is not supported check is not null #4811

Open
son2408 opened this issue Oct 31, 2022 · 3 comments
Open

LOOKUP is not supported check is not null #4811

son2408 opened this issue Oct 31, 2022 · 3 comments
Labels
type/enhancement Type: make the code neat or more efficient

Comments

@son2408
Copy link

son2408 commented Oct 31, 2022

(root@nebula) [HCMLIS]> lookup on tinhhinhdangky where tinhhinhdangky.xaId ==26797 and tinhhinhdangky.thoiDiemDangKy is not null yield id(vertex ) as id, tinhhinhdangky.NodeId as nodeId, tinhhinhdangky.thoiDiemDangKy as thoiDiemDangKy | ORDER BY $-.thoiDiemDangKy desc | limit 10
[ERROR (-1009)]: SemanticError: Expression tinhhinhdangky.thoiDiemDangKy IS NOT NULL not supported yet

Mon, 31 Oct 2022 11:24:28 +07

@son2408 son2408 added the type/enhancement Type: make the code neat or more efficient label Oct 31, 2022
@wey-gu
Copy link
Contributor

wey-gu commented Oct 31, 2022

This is indeed not yet supported.

@MuYiYong @czpmango

@wey-gu
Copy link
Contributor

wey-gu commented Oct 31, 2022

(root@nebula) [basketballplayer]> LOOKUP ON player WHERE player.name IS NOT NULL YIELD id(vertex)
[ERROR (-1009)]: SemanticError: Expression player.name IS NOT NULL not supported yet

Mon, 31 Oct 2022 14:20:39 CST

(root@nebula) [basketballplayer]> match (n:player) where n.player.name IS NOT NULL return id(n)
+-------------+
| id(n)       |
+-------------+
| "player127" |
| "player132" |
| "player135" |
| "player146" |

@son2408
Copy link
Author

son2408 commented Nov 3, 2022

(root@nebula) [basketballplayer]> LOOKUP ON player WHERE player.name IS NOT NULL YIELD id(vertex)
[ERROR (-1009)]: SemanticError: Expression player.name IS NOT NULL not supported yet

Mon, 31 Oct 2022 14:20:39 CST

(root@nebula) [basketballplayer]> match (n:player) where n.player.name IS NOT NULL return id(n)
+-------------+
| id(n)       |
+-------------+
| "player127" |
| "player132" |
| "player135" |
| "player146" |

Could you support LOOKUP check IS NOT NULL for next release. plz ?

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