REFRESH-MATERIALIZED-VIEW

Name

REFRESH MATERIALIZED VIEW

Description

该语句用于手动刷新指定的异步物化视图

语法：

REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE)?

说明：

异步刷新某个物化视图的数据

Example

1. 刷新物化视图mv1(自动计算要刷新的分区)

   REFRESH MATERIALIZED VIEW mv1;

2. 刷新名字为p_19950801_19950901和p_19950901_19951001的分区

   REFRESH MATERIALIZED VIEW mv1 partitions(p_19950801_19950901,p_19950901_19951001);

3. 强制刷新物化视图全部数据

   REFRESH MATERIALIZED VIEW mv1 complete;

Keywords

REFRESH, MATERIALIZED, VIEW

Best Practice