Categories:: Semi-structured Data Functions (Array/Object)

ARRAY_CAT¶

Returns a concatenation of two arrays.

Syntax¶

ARRAY_CAT( <array1> , <array2> )

Copy

Arguments¶

array1: The source array.
array2: The array to be appended to array1.

Returns¶

An ARRAY containing the elements from array2 appended after the elements of array1.

Usage Notes¶

Both arguments must be of ARRAY type or VARIANT containing an array.
If either argument is NULL, the function returns NULL without reporting any error.

Examples¶

This example shows how to use ARRAY_CAT():

Create a simple table and data:

CREATE TABLE array_demo (ID INTEGER, array1 ARRAY, array2 ARRAY);

Copy

INSERT INTO array_demo (ID, array1, array2) 
    SELECT 1, ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(3, 4);

Copy

Execute the query:

SELECT ARRAY_CAT(array1, array2) FROM array_demo;
+---------------------------+
| ARRAY_CAT(ARRAY1, ARRAY2) |
|---------------------------|
| [                         |
|   1,                      |
|   2,                      |
|   3,                      |
|   4                       |
| ]                         |
+---------------------------+

Copy