v.23.10New Feature
Introduce -ArgMin/-ArgMax Aggregate Combinators and Reorganize Combinators Folder
Introduce-ArgMin/-ArgMaxaggregate combinators which allow to aggregate by min/max values only. One use case can be found in #54818. This PR also reorganize combinators into dedicated folder. #54947 (Amos Bird).
Why it matters
These combinators address the need to aggregate data specifically by the minimum or maximum values, simplifying queries where only these extremal values are relevant. This feature enhances expressiveness and efficiency for use cases such as extracting values corresponding to min/max conditions without additional complex logic.How to use it
Use the new aggregate combinators by appending-ArgMin or -ArgMax to existing aggregate functions. For example, to aggregate by minimum value, apply someAggregateFunction-ArgMin in your SQL query.