drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1209) Tpch query 6 over text data (sf0.01) is returning an empty result
Date Mon, 04 Aug 2014 23:15:15 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085475#comment-14085475
] 

Steven Phillips commented on DRILL-1209:
----------------------------------------

There are two issue here. One is that the filter is filtering out every record. This looks
to be an issue with decimal, because switch to float does not return an empty result.

The other issue is that, even if the filter is filtering out every record, we shouldn't get
an empty result. The sum should be 0. This a problem with the aggregate operators (I can reproduce
it using both streaming and hash agg).
I will file a new jira for this.

> Tpch query 6 over text data (sf0.01) is returning an empty result
> -----------------------------------------------------------------
>
>                 Key: DRILL-1209
>                 URL: https://issues.apache.org/jira/browse/DRILL-1209
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow, Storage - Text & CSV
>            Reporter: Rahul Challapalli
>            Assignee: Steven Phillips
>             Fix For: 0.5.0
>
>
> git.commit.id.abbrev=caa8b78
> Query 6:
> select
>   sum(l_extendedprice * l_discount) as revenue
> from
>   lineitem
> where
>   l_shipdate >= date '1997-01-01'
>   and l_shipdate < date '1997-01-01' + interval '1' year
>   and
>   l_discount between 0.03 - 0.01 and 0.03 + 0.01
>   and l_quantity < 24
> Executing this results in an empty result which does not match the expected result of
"588302.8776" generated from postgres



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message