-
Notifications
You must be signed in to change notification settings - Fork 1.1k
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
Support recursive unnest #10660
Comments
take |
@duongcongtoai Should we just support nested unnest syntax like DuckDB? Like
|
I'm thinking of supporting both, LogicalPlan for unnest can be aware of the recursion, and the recursive query can be rewritten into this LogicalPlan with a recursion_depth |
Then, we would also need to deal with somewhat complex syntax like |
But for this query usecase
Where an operator like field access is needed between 2 unnest,it cant be supported by duckdb's syntax |
I see. It looks like a good reason. |
Is your feature request related to a problem or challenge?
These sql are not supported
If an unnest expr is a descendant of another unnest expr, this error will be thrown:
Describe the solution you'd like
Describe alternatives you've considered
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: