Thejas M Nair created HIVE-8475: ----------------------------------- Summary: add test case for use of index from not-current database Key: HIVE-8475 URL: https://issues.apache.org/jira/browse/HIVE-8475 Project: Hive Issue Type: Bug Components: Indexing Reporter: Thejas M Nair Assignee: Thejas M Nair
In hive 0.13, the following sequence fails - {code:sql} create database index_test_db; use index_test_db; create table testtb (id int, name string); create index id_index on table testtb (id) as 'COMPACT' WITH DEFERRED REBUILD in table testdb_id_idx_tb; use default; select * from index_test_db.testtb where id>2; -- fails here with error "Table not found testdb_id_idx_tb" {code} HIVE-4064 fixed the problem. It will be useful to have a test case that verifies the fix. -- This message was sent by Atlassian JIRA (v6.3.4#6332)