Bill Oliver created HIVE-8712:
---------------------------------
Summary: Cross schema query fails when table has index
Key: HIVE-8712
URL: https://issues.apache.org/jira/browse/HIVE-8712
Project: Hive
Issue Type: Bug
Components: HiveServer2
Affects Versions: 0.13.0
Reporter: Bill Oliver
I have two schemas, default and accesstesting.
I create a table in the second schema with an index.
When I query the table using a WHERE clause from the first schema, the query
fails:
use default;
drop table salary_hive;
use accesstesting;
drop table salary_hive;
use accesstesting;
create table salary_hive (idnum int, salary int, startdate timestamp, enddate
timestamp, jobcode char(20));
create index salary_hive_idnum_index on table salary_hive(idnum) as 'compact'
with deferred rebuild;
select * from accesstesting.salary_hive where 0=1;
use default;
select * from accesstesting.salary_hive where 0=1;
FAILED: SemanticException
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found
accesstesting__salary_hive_salary_hive_idnum_index__
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
