Stream Processing Windowing

Problem

You are analyzing click logs in a streaming pipeline (e.g. Kafka/Flink). You want to count clicks in non-overlapping 5-minute blocks. Write a query that outputs window_type with the value: "Tumbling windows group streaming data into fixed-size, non-overlapping time intervals, whereas sliding windows group data into overlapping intervals."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution