Aggregate Functions Grouparraymovingsum(win_size)(x) and Grouparraymovingavg(win_size)(x), Which Calculate Moving Sum/avg with or Without Window-size Limitation

Why it matters

These functions address the need to efficiently calculate moving sums and averages on grouped array data within ClickHouse, supporting time-series analysis and other scenarios where sliding window computations over grouped data arrays are required.

How to use it

Use the functions within your SQL queries by specifying the window size and the target array column, for example:

SELECT groupArrayMovingSum(3)(x), groupArrayMovingAvg(5)(x) FROM table GROUP BY key

where win_size determines the size of the moving window.