Details
-
Bug
-
Status: Reopened
-
Major
-
Resolution: Unresolved
-
None
-
None
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
Attachments
Attachments
Issue Links
- is related to
-
DRILL-1510 Join does not work in Hbase
- Open
- relates to
-
DRILL-2288 ScanBatch violates IterOutcome protocol for zero-row sources [was: missing JDBC metadata (schema) for 0-row results...]
- Closed