[HIVE-3563] Drop database cascade fails when there are indexes on any tables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 0.10.0
• Component/s: Indexing, Metastore
• Hadoop Flags: Reviewed
• Assignee: Prasad Suresh Mujumdar
• Reporter: Prasad Suresh Mujumdar
• Created: 10/Oct/12 20:48
• Updated: 28/Oct/13 03:53
• Resolved: 02/Nov/12 08:11

Description

Drop database cascade fails if any of the table has index.

create database db2;
use db2;

create table tab1 (id int, name string);
create index idx1 on table tab1(id) as 'COMPACT' with DEFERRED REBUILD;

drop database db2 cascade;

Issue Links

• is broken by: HIVE-2542 DROP DATABASE CASCADE does not drop non-native tables.
• relates to: HIVE-5664 Drop cascade database fails when the db has any tables with indexes