v.20.1New Feature

Add reset column argument to runningAccumulate for new key values

Official CH changelog text
Add optional reset column argument for runningAccumulate which allows to reset aggregation results for each new key value. #8326 (Sergey Kononenko)
Added an optional reset column argument to the runningAccumulate function that allows resetting aggregation results whenever the key value changes.

Why it matters

This feature enables users to restart the accumulation process based on changes in a specified key column, which is useful for segmented or grouped running totals without manual resets or complex query logic.

How to use it

Pass an additional column as the reset argument to runningAccumulate. The accumulation will reset each time the value in this column changes in your data sequence.

Related resources

PreviousNext