Relational Data - Aggregate Functions - Reference - Arrayconcatagg

• Alias of groupArrayArray. The function is case insensitive.

Example

SELECT *
FROM t

┌─a───────┐
│ [1,2,3] │
│ [4,5]   │
│ [6]     │
└─────────┘

Query:

SELECT array_concat_agg(a) AS a
FROM t

┌─a─────────────┐
│ [1,2,3,4,5,6] │
└───────────────┘