DROP VIEW Statement
Removes the specified view, which was originally created by the CREATE VIEW statement. Because a view is purely a logical construct (an alias for a query) with no physical data behind it, DROP VIEW only involves changes to metadata in the metastore database, not any data files in HDFS.
DROP VIEW [database_name.]view_name
Statement type: DDL
Cancellation: Cannot be cancelled.