2010/2/25 Todd Lipcon <[email protected]>: > I think you can use this existing JIRA: > http://issues.apache.org/jira/browse/HIVE-474 I'm using this JIRA. Thanks.
> > Thanks > -Todd > On Thu, Feb 25, 2010 at 2:11 AM, Mafish Liu <[email protected]> wrote: >> >> 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] > > -- [email protected]
