[ https://issues.apache.org/jira/browse/HIVE-8712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis closed HIVE-8712. ----------------------- > 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 > Fix For: 0.13.1 > > > 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)