Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

View of hive

Shulou Source: shulou.com Published: 2022-06-03 05:51:10 11月23日 Update

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.

Tags: View support query information just way time statement logic Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB vpn macOS Docker OPPO Reno