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 hliu: http://wiki.apache.org/hadoop/Hive/HiveQL/UDF ------------------------------------------------------------------------------ ||DOUBLE ||min(col) ||returns the minimum of the column in the group|| ||DOUBLE ||max(col) ||returns the maximum value of the column n the group|| - - ==== count ==== - 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. The result is a BIGINT value. The DISTINCT option can be used to return the average of the distinct values of col. - {{{ - count(1), count(DISTINCT col [, col]...) - }}} - - ==== sum ==== - Returns the sum of the elements in the group or the sum of the distinct values of the column in the group. The result is a DOUBLE value. - {{{ - sum(col), sum(DISTINCT col) - }}} - - ==== avg ==== - Returns the average of the elements in the group or the average of the distinct values of the column in the group. The result is a DOUBLE value. - {{{ - count(1), count(DISTINCT col [, col]...) - }}} - - ==== min ==== - Returns the minimum of the column in the group. The result is a DOUBLE value. - {{{ - min(col) - }}} - - ==== max ==== - Returns the maximum of the column in the group. The result is a DOUBLE value. - {{{ - max(col) - }}} -
