ARRAY

描述

根据参数构造并返回 array, 参数可以是多列或者常量

语法

ARRAY([ <element> [, ...] ])

参数

参数	说明
`<element>`	参数可以是多列或者常量

返回值

返回一个数组

举例

select array("1", 2, 1.1);

+------------------------------------------------+
| array('1', cast(2 as TEXT), cast(1.1 as TEXT)) |
+------------------------------------------------+
| ["1", "2", "1.1"]                              |
+------------------------------------------------+

select array(null, 1);

+----------------+
| array(NULL, 1) |
+----------------+
| [NULL, 1]      |
+----------------+

select array(1, 2, 3);

+----------------+
| array(1, 2, 3) |
+----------------+
| [1, 2, 3]      |
+----------------+

select array(qid, creationDate, null) from nested  limit 4;

+-------------------------------------------------------+
| array(cast(qid as DATETIMEV2(0)), creationDate, NULL) |
+-------------------------------------------------------+
| [null, "2009-06-16 07:40:56", null]                   |
| [null, "2009-06-16 07:50:05", null]                   |
| [null, "2009-06-16 08:09:18", null]                   |
| [null, "2009-06-16 08:15:45", null]                   |
+-------------------------------------------------------+

ARRAY_ZIP ARRAYS_OVERLAP