[
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)
