need some advice comparing sliding window to a single unit

[Avi Levi <av...@bluevoyant.com>]

Hi,
I want to get the average of the last x hours and compare it to the sum of
the current hour.
I thought of using ProcessWindowFunction for 8 hours and do the calculation
i.e consuming 8 hours of data and group it by the hour and do the math, but
it seems very inefficient especially considering that we are dealing with
heavy load.
is there any other more elegant solution ?

Cheers
Avi