Drop a materialized view
You must understand when to drop a materialized view to successfully drop related tables.
Drop a materialized view before performing a DROP TABLE operation on a related table. Hive does not support dropping a table that has a relationship with a materialized view.
In this task, you drop a materialized view named mv1 from the my_database database.
Drop a materialized view in my_database named mv1 .
DROP MATERIALIZED VIEW my_database.mv1;