2010/2/25 Zheng Shao <[email protected]>: > Yes definitely. Do you want to open a JIRA and post a patch? > Please link the new JIRA to the other 2 JIRA that was mentioned in the > same email thread. I'll open a jira. And the patch will be post after code and documents being arranged.
> Zheng > > On Thu, Feb 25, 2010 at 1:16 AM, Mafish Liu <[email protected]> wrote: >> Hive does not support multi-distinct in one query. >> >> We have implemented multi-distinct based on hive 0.4.2rc to our demand. >> We don't know that if Hive is intresting in this feature. >> >> 2010/2/25 Jeff Zhang <[email protected]>: >>> >>> Hi all, >>> >>> I read the tutorial of Hive, and it says that "no two aggregations can have >>> different DISTINCT columns". Could anyone tell what is the reason ? Does the >>> following Distinct will been translate to map-reduce job or just do it >>> locally ? >>> >>> INSERT OVERWRITE TABLE pv_gender_agg >>> SELECT pv_users.gender, count(DISTINCT pv_users.userid), count(DISTINCT >>> pv_users.ip) >>> FROM pv_users >>> GROUP BY pv_users.gender; >>> >>> -- >>> Best Regards >>> >>> Jeff Zhang >>> >> >> >> >> -- >> [email protected] >> > > > > -- > Yours, > Zheng > -- [email protected]
