REFRESH-MATERIALIZED-VIEW

Name

REFRESH MATERIALIZED VIEW

Description

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

syntax:

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)

   REFRESH MATERIALIZED VIEW mv1;

2. Refresh partition named p_19950801_19950901和p_19950901_19951001

   REFRESH MATERIALIZED VIEW mv1 partitions(p_19950801_19950901,p_19950901_19951001);

3. Force refresh of all materialized view data

   REFRESH MATERIALIZED VIEW mv1 complete;

Keywords

REFRESH, MATERIALIZED, VIEW

Best Practice