Analytic functions, available since Hive 0.11.0, are a special group of functions that scan the multiple input rows to compute each output value. Analytic functions are usually used with
ORDER BY, and the windowing specification. Different from the regular aggregate functions used with the
GROUP BY clause that is limited to one result value per group, analytic functions operate on windows where the input rows are ordered and grouped using flexible conditions expressed through an
OVER PARTITION clause. Though analytic functions give aggregate results, they do not group the result set. They return the group value multiple times with each record. The analytic functions offer great flexibility and functionalities ...