Hive Analytic Functions

In a world where data is everything, transforming raw data into meaningful insights require the usage of certain techniques and functions. This post would focus on the commonly used SQL analytical functions in Hive and Spark Introduction Analytic functions come packed with a lot of features such as computing aggregates such as moving sums, cumulative sums, averages etc. In addition to this, they are used to obtain ranking on the data, eliminating duplicates etc.

Continue reading