[
https://issues.apache.org/jira/browse/DRILL-1207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steven Phillips reassigned DRILL-1207:
--------------------------------------
Assignee: Steven Phillips
> 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
> Assignee: Steven Phillips
> Fix For: 0.5.0
>
> Attachments: error.log, views.txt, 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)
