SQL struct functions

Use struct functions to create Arrow structs in SQL queries.

• named_struct
• row
• struct

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

get_field

SELECT  named_struct('time', time, 'temperature', temp, 'humidity', hum) AS named_struct FROM  home WHERE  room = 'Kitchen' LIMIT 4

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

get_field

SELECT  struct(time, temp, hum) AS struct FROM  home WHERE  room = 'Kitchen' LIMIT 4

SELECT  struct(time AS 'time', temp AS 'temperature', hum) AS struct FROM  home WHERE  room = 'Kitchen' LIMIT 4