HIVE VIEW 视图

Views to Reduce Query Complexity -- 视图减少复杂查询

FROM (  SELECT * FROM people JOIN cart    ON (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;

View Odds and Ends

CREATE VIEW IF NOT EXISTS shipments(time, partCOMMENT 'Time and parts for shipments.'TBLPROPERTIES ('creator' = 'me')AS SELECT ...;

ALTER VIEW shipments SET TBLPROPERTIES ('created_at' = 'some_timestamp');