[DRILL-1211] Tpch query 3 over text data (SF 0.01) fails with a verification issue

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

Description

git.commit.id.abbrev=caa8b78

select
l.l_orderkey,
sum(l.l_extendedprice * (1 - l.l_discount)) as revenue,
o.o_orderdate,
o.o_shippriority
from
customer c,
orders o,
lineitem l
where
c.c_mktsegment = 'HOUSEHOLD'
and c.c_custkey = o.o_custkey
and l.l_orderkey = o.o_orderkey
and o.o_orderdate < date '1995-03-25'
and l.l_shipdate > date '1995-03-25'
group by
l.l_orderkey,
o.o_orderdate,
o.o_shippriority
order by
revenue desc,
o.o_orderdate
limit 10

I attached the expected and actual files