You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/07/28 20:32:42 UTC
[jira] [Created] (DRILL-1211) Tpch query 3 over text data (SF 0.01)
fails with a verification issue
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)