array_construct

Returns an array constructed from zero, one, or more inputs.

Syntax

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

Arguments

The arguments are values (or expressions that evaluate to values). The argument values can be different data types.

Returns

The data type of the returned value is ARRAY.

Examples

Construct a basic array consisting of numeric data types:

SELECT array_construct(10, 20, 30);

+-----------------------------+
| array_construct(10, 20, 30) |
+-----------------------------+
| [10,20,30]                  |
+-----------------------------+

Construct a basic array consisting of different data types:

SELECT array_construct(NULL, 'hello', 3::DOUBLE, 4, 5);

+------------------------------------------------+
| array_construct(NULL, 'hello', 3::float, 4, 5) |
+------------------------------------------------+
| [null,'hello',3.0,4,5]                         |
+------------------------------------------------+

Construct an empty array:

SELECT array_construct();

+-------------------+
| array_construct() |
+-------------------+
| []                |
+-------------------+