Apache Hive Materialized View CommandsPDF version

DROP MATERIALIZED VIEW

You can avoid making a table name unusable by dropping a dependent materialized view before dropping a table.

DROP MATERIALIZED VIEW [db_name.]materialized_view_name;
db_name.materialized_view_name
The database name followed by a name for the materialized view in dot notation.

Dropping a table that is used by a materialized view is not allowed and prevents you from creating another table of the same name. You must drop the materialized view before dropping the tables.

DROP MATERIALIZED VIEW mydb.mv1;