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/24 00:50:40 UTC
[jira] [Created] (DRILL-1183) TPCH query 14 on top of text files is
resulting in a batch read error
Rahul Challapalli created DRILL-1183:
----------------------------------------
Summary: TPCH query 14 on top of text files is resulting in a batch read error
Key: DRILL-1183
URL: https://issues.apache.org/jira/browse/DRILL-1183
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow, Storage - Text & CSV
Reporter: Rahul Challapalli
git.commit.id.abbrev=e5c2da0
The below query is resulting in an error
select
100.00 * sum(case
when p.p_type like 'PROMO%'
then l.l_extendedprice * (1 - l.l_discount)
else l.l_discount
end) / sum(l.l_extendedprice * (1 - l.l_discount)) as promo_revenue
from
lineitem l,
part p
where
l.l_partkey = p.p_partkey
and l.l_shipdate >= date '1994-08-01'
and l.l_shipdate < date '1994-08-01' + interval '1' month
message: "Failure while running fragment. < IllegalStateException:[ You tried to do a batch data read operation when you were in a state of STOP. You can only do this type of operation when you are in a state of OK or OK_NEW_SCHEMA.
However the query runs when we get rid of the last 2 filter conditions, the query runs. I attached the views used on top of text files along with the error log
--
This message was sent by Atlassian JIRA
(v6.2#6252)