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]
