STRUCT

Description

construct an struct with variadic elements and return it, Tn could be column or literal

Syntax

STRUCT( <expr1> [ , <expr2> ... ] )

Parameters

Parameter	Description
<expr>	Construct the input content for the struct

Return Value

construct an struct with variadic elements and return it, Tn could be column or literal

Example

select struct(1, 'a', "abc"),struct(null, 1, null),struct(cast('2023-03-16' as datetime));

+--------------------------------------+--------------------------------------+---------------------------------------------+
| struct(1, 'a', 'abc')                | struct(NULL, 1, NULL)                | struct(cast('2023-03-16' as DATETIMEV2(0))) |
+--------------------------------------+--------------------------------------+---------------------------------------------+
| {"col1":1, "col2":"a", "col3":"abc"} | {"col1":null, "col2":1, "col3":null} | {"col1":"2023-03-16 00:00:00"}              |
+--------------------------------------+--------------------------------------+---------------------------------------------+