SQL struct functions
Use struct functions to create Arrow structs in SQL queries.
named_struct
Returns an Arrow struct using the specified name and input expressions pairs.
named_struct(expression1_name, expression1_input[, ..., expression_n_name, expression_n_input])
Arguments
- expression_n_name: Name of the column field. Must be a constant string.
- expression_n_input: Expression to include in the output struct. Can be a constant, column, or function, and any combination of arithmetic or string operators.
Related functions
row
Alias of struct
.
struct
Returns an Arrow struct using the specified input expressions optionally named.
Fields in the returned struct use the optional name or the cN
naming convention.
Fields in the returned struct use the cN
naming convention (for example: c0
, c1
, c2
, etc.)
unless you specify custom names using the AS
operator within individual expressions.
struct(expression1[, ..., expression_n])
Arguments
- expression1, expression_n: Expression to include in the output struct. Can be a constant, column, or function, and any combination of arithmetic or string operators.
Aliases
- row
Related functions
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB Clustered and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.