说明:
CREATE MATERIALIZED
创建物化视图:
CREATE MATERIALIZED VIEW [IF NOT EXISTS] mv_identifier[ENABLE | DISABLE REWRITE][COMMENT mv_comment][WITH META LINK][TBLPROPERTIES (key1=value1, key2=value2,...)][AS] select_query
DROP MATERIALIZED
删除物化视图:
DROP MATERIALIZED VIEW [IF EXISTS] mv_identifier
DESCRIBE MATERIALIZED
描述物化视图:
[DESCRIBE | DESC] MATERIALIZED VIEW mv_identifier
REFRESH MATERIALIZED
刷新物化视图:
REFRESH MATERIALIZED VIEW mv_identifier
SHOW MATERIALIZED VIEW JOBS
显示物化视图的执行任务列表,可以了解到物化视图的刷新历史和状态。
SHOW MATERIALIZED VIEW JOBS IN mv_identifier