Shulou(Shulou.com)06/03 Report--

Create a view: create view view_piaofang as select * from t_name

View views: show tables; # has both tables and views

Show views # View only

View the details of the view

Desc formatted | extended

Delete View

Drop view view_name

Precautions for working with views:

The attempt in Hive is just a shortcut to a sql statement, the view in hive is only a logical view, there is no materialized view hive, there is no support for addition, deletion and modification, only the view of querying hive is supported, and the query will only be executed when it is queried.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.