[jira] [Created] (DRILL-1209) Tpch query 6 over text data (sf0.01) is returning an empty result

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-1209:
----------------------------------------

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


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)