ARRAY

Description

construct an array with variadic elements and return it, T could be column or literal

Syntax

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

Parameters

Parameter	Description
<element>	The parameter can be multiple columns or constants

Return Value

Returns an array.

Example

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]                   |
+-------------------------------------------------------+