REFRESH-MATERIALIZED-VIEW

Name

REFRESH MATERIALIZED VIEW

Description

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

语法：

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

说明：

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

Example

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

1. REFRESH MATERIALIZED VIEW mv1; 2. 刷新名字为p_19950801_19950901和p_19950901_19951001的分区

1. REFRESH MATERIALIZED VIEW mv1 partitions(p_19950801_19950901,p_19950901_19951001); 3. 强制刷新物化视图全部数据

1. REFRESH MATERIALIZED VIEW mv1 complete;

Keywords

1. REFRESH, MATERIALIZED, VIEW

Best Practice