Skip to main content

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