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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Execution - Flow, Storage - Text & CSV
• Assignee: Steven Phillips
• Reporter: Rahul Kumar Challapalli
• Due: 11/Aug/14
• Created: 24/Jul/14 16:37
• Updated: 01/May/15 22:01
• Resolved: 14/Aug/14 19:29

Description

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.