FunctionsArray

array_concat

Concatenates all input arrays for each row into a single array preserving element order.

array_concat(…) → String

Kind · scalar

Concatenates all input arrays for each row into a single array preserving element order.

Part of the Array family.

array_compact

Returns an array where consecutive equal elements are collapsed into a single occurrence.

array_concat_agg

Concatenates array values from each row of the group into a single array, preserving row order within each partial aggregate.