Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
0.13.0
-
None
Description
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_
Attachments
Issue Links
- duplicates
-
HIVE-4064 Handle db qualified names consistently across all HiveQL statements
- Closed