-
Notifications
You must be signed in to change notification settings - Fork 1.3k
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
Create fixed size list table with syntax <type name>[<length>] #10303
Comments
I would like to work on this is no one else is working on it. |
take |
Thanks @vaibhawvipul - I think the first thing to do is see what happens if you try to parse this syntax -- here is the sqlparser syntax: https://docs.rs/sqlparser/latest/sqlparser/ast/enum.DataType.html# |
I'm not familiar with how an external table is created, but I think the change here does not matter whether the table is external or not. If it does matter, we can support the non-external table first |
I think we may be able to use the syntax https://docs.rs/sqlparser/latest/sqlparser/ast/enum.DataType.html#variant.Array So something like this to create a 256 integer array CREATE TABLE foo(my_col INT[256]) This was added by @universalmind303 in apache/datafusion-sqlparser-rs#1230 (and will be available once #10392 gets merged -- shout out to @tisonkun and @jmhain) |
I want to make my first contribution and this issue looks simple enough. |
Is your feature request related to a problem or challenge?
To create a table with fixed size list, we can only do it by casting
In DuckDB, they has syntax like
<type name> [<length>]
, which I think is quite niceWhat we don't have the syntax supported yet, we need to fix the parser first
Describe the solution you'd like
Expect result
Describe alternatives you've considered
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: