[ https://issues.apache.org/jira/browse/HIVE-14256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan resolved HIVE-14256. ------------------------------------- Resolution: Fixed Fix Version/s: 2.3.0 > CBO: Rewrite aggregate + distinct as 3-stage DAG > ------------------------------------------------ > > Key: HIVE-14256 > URL: https://issues.apache.org/jira/browse/HIVE-14256 > Project: Hive > Issue Type: Improvement > Components: CBO > Affects Versions: 2.2.0 > Reporter: Gopal V > Priority: Major > Fix For: 2.3.0 > > > {code} > select sum(ss_net_profit), count(distinct ss_customer_sk) from store_sales; > {code} > is very slow, while manually sub-aggregating this makes it much faster. > {code} > select sum(v), count(c) from > ( select sum(ss_net_profit) as v, ss_customer_sk as k from store_sales group > by ss_customer_sk); > {code} > Query28 in TPC-DS would be an example of whether this would be valuable. -- This message was sent by Atlassian JIRA (v7.6.3#76005)