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 2015/06/01 23:39:18 UTC
[jira] [Updated] (DRILL-3239) Join between empty hive tables throws
an IllegalStateException
[ https://issues.apache.org/jira/browse/DRILL-3239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli updated DRILL-3239:
-------------------------------------
Attachment: error.log
> 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)