Using Apache Hive
Also available as:
PDF

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;