drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1210) Tpch query 10 over text data (SF 0.01) fails with a verification issue
Date Mon, 28 Jul 2014 18:24:41 GMT
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)

Mime
View raw message