Patch uploaded. Please have a review at https://issues.apache.org/jira/browse/HIVE-474
2010/2/26 Mafish Liu <[email protected]>: > 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] > -- [email protected]
