⚙️Tumbling Window
Also known as Fixed Window
Windows that are all one size. Each starts when the last ends.
Think of it like
It is like the hours on a clock. Each hour starts when the last one ends, and none overlap.
Example
A power company adds up use in 15-minute windows. Its bills are based on those same blocks.
Why it matters
Each event is counted once, so the windows add up to the whole. Reports and bills need that.
Definition
Example code
sql
SELECT window_start, page, COUNT(*) AS views
FROM TUMBLE(TABLE clicks, DESCRIPTOR(ts), INTERVAL '5' MINUTES)
GROUP BY window_start, window_end, page;Common mistake
Key takeaways
- 1Fixed size. Every window is the same length.
- 2No overlap. One window per event.
- 3Adds up. The windows sum to the whole.