Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Fri, 20 Feb 2015 22:54:11 +0000 (UTC)
From: "Aman Sinha (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.12773543.1423509034000.99425.1424472851709@Atlassian.JIRA>
In-Reply-To: <JIRA.12773543.1423509034000@Atlassian.JIRA>
References: <JIRA.12773543.1423509034000@Atlassian.JIRA>
 <JIRA.12773543.1423509034391@arcas>
Subject: [jira] [Resolved] (DRILL-2191) Aggregation on columns with case
 statements returns wrong results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Aman Sinha resolved DRILL-2191.
-------------------------------
    Resolution: Fixed

> Aggregation on columns with case statements returns wrong results
> -----------------------------------------------------------------
>
>                 Key: DRILL-2191
>                 URL: https://issues.apache.org/jira/browse/DRILL-2191
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Abhishek Girish
>            Assignee: Aman Sinha
>            Priority: Critical
>             Fix For: 0.8.0
>
>         Attachments: explain_plan_q1_with_case.txt, explain_plan_q1_without_case.txt
>
>
> Dataset: TPCDS SF 1
> The following queries returns wrong results:
> *Query 1*
> SELECT
>     ss_quantity ,
>     SUM(wholesale) AS sum_wholesale
> FROM
>     (
>         SELECT
>             ss_quantity ,
>       sum(case when s.ss_quantity between 1 AND 2 then s.ss_wholesale_cost else 0 end) as wholesale
>         FROM
>             store_sales s
>         WHERE
>            s.ss_quantity between 1 AND 2
>         GROUP BY
>                 ss_quantity,
>                         ss_store_sk
>     ) dat
> GROUP BY        ss_quantity
> ORDER BY        ss_quantity;
> *Query 2:*
> SELECT
>         c.c_birth_country,
>         sum(case when s.ss_quantity between 1 AND 2 then s.ss_wholesale_cost else 0 end) as wholesale
>    FROM
>         store_sales s
>    JOIN
>         customer c
>      ON
>         s.ss_customer_sk = c.c_customer_sk
> GROUP BY
>         c.c_birth_country
> Order by c.c_birth_country;
> The returned results have issues with decimal placement. Example:
> Rows returned from Drill:
> 	3	2227134.0
> 	3	2128570.0
> Rows returned from Postgres:
> 	3	22271.34
> 	3	21285.7
> The results are correct when case statements are removed. 


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