[HIVE-18991] Drop database cascade doesn't work with materialized views

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Materialized views, Metastore
• Assignee: Jesús Camacho Rodríguez Assign to me
• Reporter: Alan Gates
• Created: 19/Mar/18 19:49
• Updated: 27/Feb/24 22:24
• Resolved: 10/Apr/18 22:14

Description

Create a database, add a table and then a materialized view that depends on the table.  Then drop the database with cascade set.  Sometimes this will fail because when HiveMetaStore.drop_database_core goes to drop all of the tables it may drop the base table before the materialized view, which will cause an integrity constraint violation in the RDBMS.  To resolve this that method should change to fetch and drop materialized views before tables.

cc [~jcamachorodriguez]

Issue Links

• relates to: HIVE-18620 Improve error message while dropping a table that is part of a materialized view