Rahul Challapalli created DRILL-1210:
----------------------------------------
Summary: Tpch query 10 over text data (SF 0.01) fails with a
verification issue
Key: DRILL-1210
URL: https://issues.apache.org/jira/browse/DRILL-1210
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow, Storage - Text & CSV
Reporter: Rahul Challapalli
git.commit.id.abbrev=caa8b78
select
c.c_custkey,
c.c_name,
sum(l.l_extendedprice * (1 - l.l_discount)) as revenue,
c.c_acctbal,
n.n_name,
c.c_address,
c.c_phone,
c.c_comment
from
customer c,
orders o,
lineitem l,
nation n
where
c.c_custkey = o.o_custkey
and l.l_orderkey = o.o_orderkey
and o.o_orderdate >= date '1994-03-01'
and o.o_orderdate < date '1994-03-01' + interval '3' month
and l.l_returnflag = 'R'
and c.c_nationkey = n.n_nationkey
group by
c.c_custkey,
c.c_name,
c.c_acctbal,
c.c_phone,
n.n_name,
c.c_address,
c.c_comment
order by
revenue desc
limit 20
I attached the expected and actual results. Let me know if you need anything
else
--
This message was sent by Atlassian JIRA
(v6.2#6252)
