# 语法参考
- 创建智能物化视图 基于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