iBenny created HIVE-18040:
-----------------------------
Summary: the index can't be deleted if we make the table and the
index are in the different databases.
Key: HIVE-18040
URL: https://issues.apache.org/jira/browse/HIVE-18040
Project: Hive
Issue Type: Bug
Affects Versions: 1.2.1
Reporter: iBenny
If we made the table and the index are in the different databases, for example:
create table db1.t -> create index t_i on db1.t -> rename db1.t to db2.t. In
this case this knid of index can't be deleted successfully.
Workaround:
* Created the same index table in db1 (using create table t1 as select * from).
* DROPPED the index using HIVE CLI (did not work via Beeline or HUE).
* DROPPED the newly created indexed table on db1.
* Checked the index - it was gone.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
