Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by ZhengShao: http://wiki.apache.org/hadoop/Hive/HiveQL/UDF ------------------------------------------------------------------------------ }}} - === Built in Aggregate (GROUP BY) Functions === + == Built in Aggregate (GROUP BY) Functions == The following are built in 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||
