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/GroupBy ------------------------------------------------------------------------------ {{{ FROM pv_users INSERT OVERWRITE TABLE pv_gender_sum - SELECT pv_users.gender, count_distinct(pv_users.userid) + SELECT pv_users.gender, count(DISTINCT pv_users.userid) GROUP BY pv_users.gender INSERT OVERWRITE DIRECTORY '/user/facebook/tmp/pv_age_sum' - SELECT pv_users.age, count_distinct(pv_users.userid) + SELECT pv_users.age, count(DISTINCT pv_users.userid) GROUP BY pv_users.age; }}}
