Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sat, 16 Jul 2016 00:09:20 +0000 (UTC)
From: "Gopal V (JIRA)" <jira@apache.org>
To: dev@hive.apache.org
Message-ID: <JIRA.12989987.1468627730000.47559.1468627760473@Atlassian.JIRA>
In-Reply-To: <JIRA.12989987.1468627730000@Atlassian.JIRA>
References: <JIRA.12989987.1468627730000@Atlassian.JIRA> <JIRA.12989987.1468627730146@arcas>
Subject: [jira] [Created] (HIVE-14256) CBO: Rewrite aggregate + distinct as
 3-stage DAG
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sat, 16 Jul 2016 00:09:22 -0000

Gopal V created HIVE-14256:
------------------------------

             Summary: 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


{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}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)