Section.12.137. Performing-aggregations-using-windowing-functions

Performing aggregations using windowing functions in Hive involves using functions such as SUM(), AVG(), MIN(), MAX(), and COUNT() over a window or subset of rows.

Here is an example of how to use windowing functions