Streaming Aggregation

The use of a time-based window with many-rows-in, one-row-out behavior.

To perform streaming aggregation, use the SQL constructs SELECT STREAM DISTINCT … or, more commonly, SELECT STREAM … GROUP BY (see the GROUP BY clause).