Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

View of hive

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Internet Technology

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report