array_concat_agg
- 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] │
└───────────────┘