Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 9 Jun 2015 09:58:00 +0000 (UTC)
From: "wangmeng (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12836488.1433839921000.26566.1433843880573@Atlassian.JIRA>
In-Reply-To: <JIRA.12836488.1433839921000@Atlassian.JIRA>
References: <JIRA.12836488.1433839921000@Atlassian.JIRA>
 <JIRA.12836488.1433839921153@arcas>
Subject: [jira] [Updated] (HIVE-10971) count(*) with count(distinct) gives
 wrong results when hive.groupby.skewindata=true
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-10971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

wangmeng updated HIVE-10971:
----------------------------
    Component/s:     (was: Hive)
                 Logical Optimizer

> count(*) with count(distinct) gives wrong results when hive.groupby.skewindata=true
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-10971
>                 URL: https://issues.apache.org/jira/browse/HIVE-10971
>             Project: Hive
>          Issue Type: Bug
>          Components: Logical Optimizer
>    Affects Versions: 1.2.0
>            Reporter: wangmeng
>            Assignee: wangmeng
>
> When hive.groupby.skewindata=true, the following query based on TPC-H gives wrong results:
> {code}
> set hive.groupby.skewindata=true;
> select l_returnflag, count(*), count(distinct l_linestatus)
> from lineitem
> group by l_returnflag
> limit 10;
> {code}
> The query plan shows that it generates only one MapReduce job instead of two theoretically, which is dictated by hive.groupby.skewindata=true.
> The problem arises only when {noformat}count(*){noformat} and {noformat}count(distinct){noformat} exist together.


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