[jira] [Created] (DRILL-3239) Join between empty hive tables throws an IllegalStateException

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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)