FunctionsArray

array_count

Counts array elements per row, or counts elements equal to the optional comparison value.

array_count(…) → UInt64

Kind · scalar

Counts array elements per row, or counts elements equal to the optional comparison value.

Part of the Array family.

array_concat_agg

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

array_cum_sum

Returns an array where each position contains the running sum from the first element through that position.