Skip to main content

ARRAY_CONCAT

Concats two arrays.

Syntax

ARRAY_CONCAT( <array1>, <array2> )

Examples

SELECT ARRAY_CONCAT([1, 2], [3, 4]);

┌──────────────────────────────┐
│ array_concat([1, 2], [3, 4])
├──────────────────────────────┤
[1,2,3,4]
└──────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today