第七章 试图
view1
create view shorter_join as
select * from people join cart
on(cart.people_id=people.id) where firstname='dirk'
select lastname from shorter_join where id=3
view2
create view if not exists shipments(time,part)
comment 'time and parts for shipments'
tblproperties('creator'='me')
as select...;
通过试图建table
create table shipments2 like shipments
删除view
drop view if exists shipments
修改view属性
alter view shipments set tblproperties('created_at'='some_timestamp')