[DRILL-3239] Join between empty hive tables throws an IllegalStateException

• Type: Bug
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Rahul Kumar Challapalli
• Created: 01/Jun/15 21:38
• Updated: 03/Jan/17 15:05

Description

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

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)

Below is the hive ddl I used

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';

I attached the log files

Issue Links

• is related to: DRILL-1510 Join does not work in Hbase
• relates to: DRILL-2288 ScanBatch violates IterOutcome protocol for zero-row sources [was: missing JDBC metadata (schema) for 0-row results...]