Repository navigation
Create a struct with the specified field names and values #5861
Description
Is your feature request related to a problem or challenge?
I want to construct struct from literal or expression by using sql or rust interface.
like:
- https://docs.databricks.com/sql/language-manual/functions/named_struct.html
- https://duckdb.org/docs/sql/data_types/struct.html
- https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS
Describe the solution you'd like
Add a NamedStruct expression similar to what spark does
sql usage:
SELECT named_struct('a', 1, 'b', 2, 'c', 3);Describe alternatives you've considered
No response
Additional context
If this issue is useful, I will implement it
Activity
crepererum commentedon Apr 20, 2023
Note that there is currently NO way to construct a struct with custom field names, because DF also doesn't support casting structs that were constructed using
struct(1, 2, 3). But even if such a workaround would be possible, I think having a direct constructor would still be nice.alamb commentedon Mar 27, 2024
There is a PR up to support
named_struct#9743 and work afoot to support nicer literal syntax: #9820 🚀