STRUCT

描述

根据给定的值构造并返回 struct ，参数可以是多列或常量

语法

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

参数

参数	说明
<expr>	构造 struct 的输入内容

返回值

根据给定的值构造并返回 struct ，参数可以是多列或常量

举例

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"}              |
+--------------------------------------+--------------------------------------+---------------------------------------------+