array_concat
Concatenates multiple arrays into one array that contains all the elements in the arrays.
Elements in the arrays to concatenate can be of the same type or different types. However, we recommend that the elements be of the same type.
Nulls are processed as normal values.
Syntax
array_concat(input0, input1, ...)
Parameters
input
: one or more arrays that you want to concatenate. Specify arrays in the
(input0, input1, ...)
format. This function supports the following types of array elements: BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, VARCHAR, DECIMALV2, DATETIME, DATE, and JSON.
JSON is supported from 2.5.
Return value
Returns an array that contains all the elements held in the arrays that are specified by the
input
parameter. The elements of the returned array are of the same data type as the elements of the input arrays. Additionally, the elements of the returned array follow the order of the input arrays and their elements.
Examples
Example 1: Concatenate arrays that contain numeric elements.
select array_concat([57.73,97.32,128.55,null,324.2], [3], [5]) as res;
+-------------------------------------+
| res |
+-------------------------------------+
| [57.73,97.32,128.55,null,324.2,3,5] |
+-------------------------------------+