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 […]

Review Comments
default image

I am a plsql developer. Intrested to move into bigdata.

Neetika Singh ITA Hadoop in Dec/2016 December 22, 2016