drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3239) Join between empty hive tables throws an IllegalStateException
Date Mon, 01 Jun 2015 21:39:18 GMT
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


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
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
LOCATION '/drill/testdata/Tpch0.01/orc/orders';

I attached the log files

This message was sent by Atlassian JIRA

View raw message