# Tumbling Window

> Windows that are all one size. Each starts when the last ends.

**Field:** Data Engineering  
**Category:** Processing  
**Also known as:** Fixed Window

## Think of it like

It is like the hours on a clock. Each hour starts when the last one ends, and none overlap.

## Definition

A tumbling window is a window of fixed size that never overlaps the next one. Each event falls into exactly one window. A 5-minute tumbling window gives one result for 10:00 to 10:05, then one for 10:05 to 10:10, and so on. It is the simplest window and the most common.

## Example

A power company adds up use in 15-minute windows. Its bills are based on those same blocks.

## 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;
```

Flink SQL: page views in 5-minute tumbling windows.

## Why it matters

Each event is counted once, so the windows add up to the whole. Reports and bills need that.

## Common mistake

Using it for a moving average. That needs a sliding window.

## Three principles

- **Fixed size.** Every window is the same length.
- **No overlap.** One window per event.
- **Adds up.** The windows sum to the whole.

## Related terms

- [Windowing (Stream Processing)](https://learn.benibix.com/term/data/windowing)
- [Sliding Window](https://learn.benibix.com/term/data/sliding-window)
- [Session Window](https://learn.benibix.com/term/data/session-window)
- [Watermark (Stream Processing)](https://learn.benibix.com/term/data/watermark)

## Told apart from

- [Tumbling Window vs Sliding Window](https://learn.benibix.com/compare/tumbling-window-vs-sliding-window): People think any window that comes round again is a tumbling window. Tumbling windows touch but never overlap, so each event is counted once. Sliding windows overlap, so one event falls in more than one. Use tumbling for totals and bills. Use sliding for moving averages and alerts.

![Three timelines of the same dots. Tumbling windows cut the line into boxes that touch and never overlap. Sliding windows overlap, so one dot falls in more than one box. Session windows wrap each burst of dots and close after a gap.](https://learn.benibix.com/diagrams/stream-windows.svg)

---

Source: https://learn.benibix.com/term/data/tumbling-window
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
