Apache Hive Cookbook

Dropping views

In this recipe, you will learn how to drop a view in Hive.

Getting ready

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.

How to do it…

The following statement drops a view in Hive:

Drop view Hive_view;