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 AS
SELECT * FROM people JOIN cart
ON (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, part
COMMENT 'Time and parts for shipments.'
TBLPROPERTIES ('creator' = 'me')
AS SELECT ...;

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