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

[Rahul Challapalli (JIRA)]

Rahul Challapalli created DRILL-1211:
----------------------------------------

             Summary: Tpch query 3 over text data (SF 0.01) fails with a 
verification issue
                 Key: DRILL-1211
                 URL: https://issues.apache.org/jira/browse/DRILL-1211
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow, Storage - Text & CSV
            Reporter: Rahul Challapalli


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



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