REFRESH-MATERIALIZED-VIEW

Name

REFRESH MATERIALIZED VIEW

Description

This statement is used to manually refresh the specified asynchronous materialized view

syntax:

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

Explanation:

Asynchronous refresh of data for a materialized view

Example

1. Refresh materialized view mv1 (automatically calculate the partition to be refreshed)

1. REFRESH MATERIALIZED VIEW mv1; 2. Refresh partition named p_19950801_19950901和p_19950901_19951001

1. REFRESH MATERIALIZED VIEW mv1 partitions(p_19950801_19950901,p_19950901_19951001); 3. Force refresh of all materialized view data

1. REFRESH MATERIALIZED VIEW mv1 complete;

Keywords

1. REFRESH, MATERIALIZED, VIEW

Best Practice