语法参考

基于SQL查询创建物化视图：

CREATE LAKE MATERIALIZED VIEW [IF NOT EXISTS] view_name
[(<col_name> [COMMENT <col_comment>], ...)]
[COMMENT '...']
[PARTITIONED BY col1, col2, ...]
[ CLUSTERED BY (col_name3, col_name4, ...)
[ SORTED BY (col_name [ ASC | DESC], ...)]
INTO num_buckets BUCKETS]
[TBLPROPERTIES ('key'='value', ...)]
REFRESH POLICY AUTO | INCREMENTAL | INCREMENTAL STRICT | FULL
SCHEDULE EVERY  MINUTES| HOURS | DAYS
AS <SELECT query>;

REFRESH POLICY AUTO | INCREMENTAL | INCREMENTAL STRICT | FULL 用于指定刷新策略

SCHEDULE EVERY MINUTES| HOURS | DAYS 用于指定刷新时效，参数限制如下：

• MINUTES ：1 < = M <= 60
• HOURS：1 <= H <= 72
• DAYS：1 <= D <= 7