View of hive
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.