Alan Gates created HIVE-18991:
---------------------------------
Summary: Drop database cascade doesn't work with materialized views
Key: HIVE-18991
URL: https://issues.apache.org/jira/browse/HIVE-18991
Project: Hive
Issue Type: Bug
Components: Materialized views, Metastore
Affects Versions: 3.0.0
Reporter: Alan Gates
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]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
