I think you can use this existing JIRA: http://issues.apache.org/jira/browse/HIVE-474
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] >
