QQ
交流群:335671559
视图可以保存查询语句,可以像对待表一样对待视图,它只是一个逻辑上的结构,目前hive还不支持实例化的视图
7.1 视图降低复杂度
7.2创建视图方式原始语句FROM (SELECT * FROM people JOIN cartON (cart.people_id=people.id) WHERE firstname='john') a SELECT a.lastname WHERE a.id=3;
创建视图CREATE VIEW shorter_join ASSELECT * FROM people JOIN cartON (cart.people_id=people.id) WHERE firstname='john';
使用视图SELECT lastname FROM shorter_join WHERE id=3;
7.3 复制视图CREATE VIEW IF NOT EXISTS shipments(time, part)COMMENT 'Time and parts for shipments.'TBLPROPERTIES ('creator' = 'me')AS SELECT ...;
CREATE TABLE shipments2LIKE shipments;
7.4 删除视图
DROP VIEW IF EXISTS shipments
7.5 视图显示
视图和表在展示上是一致的,所以使用SHOW TABLES就可以展示出视图,没有SHOW VIEWS用法
视图是只读的,只可以修改视图元数据TBLPROPERTIES
ALTER VIEW shipments SET TBLPROPERTIES ('created_at' = 'some_timestamp');