Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/UDF" page has been changed by ArvindPrabhakar.
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF?action=diff&rev1=44&rev2=45

== Builtin Aggregate Functions (UDAF) ==
The following are builtin aggregate functions are supported in Hive:
<10%>Return Type''' ''' <10%>Name(Signature)''' ''' Description''' '''

 bigint count(1), count(DISTINCT col [, col]...) count(1) returns the number of members
in the group, whereas the count(DISTINCT col) gets the count of distinct values of the columns
in the group 
+ bigint count(*), count(expr), count(DISTINCT expr[, expr...])  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 nonNULL; count(DISTINCT expr[, expr])
 Returns the number of rows for which the supplied expression(s) are unique and nonNULL.

double sum(col), sum(DISTINCT col) Returns the sum of the elements in the group or
the sum of the distinct values of the column in the group 
double avg(col), avg(DISTINCT col) Returns the average of the elements in the group
or the average of the distinct values of the column in the group 
double min(col) Returns the minimum of the column in the group 
