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-1207) Tpch query 18 on top of text files fails with IOBException
Date Mon, 28 Jul 2014 18:08:44 GMT
Rahul Challapalli created DRILL-1207:
----------------------------------------

             Summary: Tpch query 18 on top of text files fails with IOBException
                 Key: DRILL-1207
                 URL: https://issues.apache.org/jira/browse/DRILL-1207
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow, Execution - RPC
            Reporter: Rahul Challapalli
         Attachments: error.log, views.txt

git.commit.id.abbrev=caa8b78

select
  c.c_name,
  c.c_custkey,
  o.o_orderkey,
  o.o_orderdate,
  o.o_totalprice,
  sum(l.l_quantity)
from
  customer c,
  orders o,
  lineitem l
where
  o.o_orderkey in (
    select
      l_orderkey
    from
      lineitem
    group by
      l_orderkey having
        sum(l_quantity) > 300
  )
  and c.c_custkey = o.o_custkey
  and o.o_orderkey = l.l_orderkey
group by
  c.c_name,
  c.c_custkey,
  o.o_orderkey,
  o.o_orderdate,
  o.o_totalprice
order by
  o.o_totalprice desc,
  o.o_orderdate
limit 100

I attached the error logs and the sql used to create the views. Let me know if you need anything
else



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

Mime
View raw message