SQL - Hopping Windows

About

Data is aggregated over a Hopping Window where you can define:

• the size of the window (for instance 5 seconds)
• the hop (when the window will advance)

For a size of 5s and a hop of 1s, there will be 5 aggregate windows.

See Ksql