Rahul Challapalli created DRILL-3239:
----------------------------------------
Summary: Join between empty hive tables throws an
IllegalStateException
Key: DRILL-3239
URL: https://issues.apache.org/jira/browse/DRILL-3239
Project: Apache Drill
Issue Type: Bug
Components: Storage - Hive
Reporter: Rahul Challapalli
Assignee: Venki Korukanti
Attachments: error.log
git.commit.id.abbrev=6f54223
Created 2 hive tables on top of tpch data in orc format. The tables are empty.
Below query returns 0 rows from hive. However it fails with an
IllegalStateException from drill
{code}
select * from customer c, orders o where c.c_custkey = o.o_custkey;
Error: SYSTEM ERROR: java.lang.IllegalStateException: You tried to do a batch
data read operation when you were in a state of NONE. You can only do this
type of operation when you are in a state of OK or OK_NEW_SCHEMA.
Fragment 0:0
[Error Id: 8483cab2-d771-4337-ae65-1db41eb5720d on qa-node191.qa.lab:31010]
(state=,code=0)
{code}
Below is the hive ddl I used
{code}
create table if not exists tpch01_orc.customer (
c_custkey int,
c_name string,
c_address string,
c_nationkey int,
c_phone string,
c_acctbal double,
c_mktsegment string,
c_comment string
)
STORED AS orc
LOCATION '/drill/testdata/Tpch0.01/orc/customer';
create table if not exists tpch01_orc.orders (
o_orderkey int,
o_custkey int,
o_orderstatus string,
o_totalprice double,
o_orderdate date,
o_orderpriority string,
o_clerk string,
o_shippriority int,
o_comment string
)
STORED AS orc
LOCATION '/drill/testdata/Tpch0.01/orc/orders';
{code}
I attached the log files
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
