v.1.1.54337New Feature

Extension of -ForEach Combinator for Multi-Argument Aggregate Functions

Official CH changelog text
The -ForEach aggregate function combinator is extended for the case of aggregate functions of multiple arguments.
Extension of the -ForEach aggregate function combinator to support aggregate functions that accept multiple arguments.

Why it matters

This feature allows users to apply the -ForEach combinator to multi-argument aggregate functions, enabling aggregation across multiple corresponding arrays or columns within a single query. It solves the problem of lacking support for multi-argument aggregate functions with the -ForEach combinator, thereby increasing flexibility and expressiveness in aggregate queries.

How to use it

To use this feature, apply the -ForEach combinator to an aggregate function that takes multiple arguments. Pass arrays or columns as arguments so that the combinator will execute the multi-argument aggregate function element-wise over the provided data arrays.

Example:
SELECT
    multiArgAggregateFunction-ForEach(array1, array2, array3)
FROM table

Replace multiArgAggregateFunction with the desired aggregate function that requires multiple parameters.
PreviousNext