[jira] [Created] (DRILL-1184) TPCH Query 19 on top of text data (0.01 GB) does not match the baselines generated through postgres

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

Rahul Challapalli created DRILL-1184:
----------------------------------------

             Summary: TPCH Query 19 on top of text data (0.01 GB) does not match the baselines generated through postgres
                 Key: DRILL-1184
                 URL: https://issues.apache.org/jira/browse/DRILL-1184
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow, Storage - Text & CSV
            Reporter: Rahul Challapalli
         Attachments: views.txt

git.commit.id.abbrev=e5c2da0

Query : 

select
  sum(l.l_extendedprice* (1 - l.l_discount)) as revenue
from
  lineitem l,
  part p
where
  p.p_partkey = l.l_partkey
  and (
  (
    p.p_brand = 'Brand#41'
    and p.p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
    and l.l_quantity >= 2 and l.l_quantity <= 2 + 10
    and p.p_size between 1 and 5
    and l.l_shipmode in ('AIR', 'AIR REG')
    and l.l_shipinstruct = 'DELIVER IN PERSON'
  )
  or
  (
    p.p_brand = 'Brand#13'
    and p.p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
    and l.l_quantity >= 14 and l.l_quantity <= 14 + 10
    and p.p_size between 1 and 10
    and l.l_shipmode in ('AIR', 'AIR REG')
    and l.l_shipinstruct = 'DELIVER IN PERSON'
  )
  or
  (
    p.p_brand = 'Brand#55'
    and p.p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
    and l.l_quantity >= 23 and l.l_quantity <= 23 + 10
    and p.p_size between 1 and 15
    and l.l_shipmode in ('AIR', 'AIR REG')
    and l.l_shipinstruct = 'DELIVER IN PERSON'
  ))

Results :
  - Drill : 108600
  - Postgres : 106598.6290

Attached the DDL for the views created before running this query.



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