Daily Archives: June 24, 2015


Hive Aggregate Functions 1

Creating Table in HIVE :

Aggregated Functions and Normal Queries:

SUM Returns the sum of the elements in the group or sum of the distinct values of the column in the group.

Count count(*) – Returns the total number of retrieved rows, including rows containing NULL values; count(expr) – Returns the number of rows for which the supplied expression is non-NULL; count(DISTINCT expr[, expr]) – Returns the […]