Overview of Analytics or Windowing Functions


Let us get an overview of Analytics or Windowing Functions in Hive.

  • Aggregate Functions (sum, min, max, avg)
  • Window Functions (lead, lag, first_value, last_value)
  • Rank Functions (rank, dense_rank, row_number etc)
  • For all the functions we use OVER
  • For aggregate functions we typically use PARTITION BY
  • For ranking and windowing functions we might use ORDER BY or PARTITION BY partition_column ORDER BY sorting_column.

Practice hive on state of the art Big Data cluster - https://labs.itversity.com
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses