[ https://issues.apache.org/jira/browse/HIVE-8475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173012#comment-14173012 ]
Thejas M Nair edited comment on HIVE-8475 at 10/15/14 9:52 PM: --------------------------------------------------------------- HIVE-8475-0.13.1.patch - patch for anyone interested in backporting the relevant portion of fix to 0.13 branch. (not for commit) was (Author: thejas): HIVE-8475-0.13.1.patch - patch for anyone interested in backporting the relevant portion of fix to 0.13 branch. > 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)