[ https://issues.apache.org/jira/browse/HIVE-8475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14175544#comment-14175544 ]
Thejas M Nair commented on HIVE-8475: ------------------------------------- [~vikram.dixit] It will be useful to add this test case in 0.14 as well, to make sure there is no regression. > 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 > Attachments: HIVE-8475-0.13.1.patch, HIVE-8475.1.patch > > > 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)