In this recipe, you will learn how to drop a view in Hive.
The DROP VIEW
command removes the view from the database. It removes the metadata, but the base table remains intact. If a base table is a view that is dropped, then the dependent view remains in an invalid state, which is either dropped or recreated. The general syntax for dropping a view is as follows:
DROP VIEW [IF EXISTS] view_name;
Where:
[IF EXISTS]
: Is an optional clause. If there is an attempt to drop a view that does not exist, an error is thrown. To prevent this error, the IF EXISTS
clause is specified.