ALTER MATERIALIZED VIEW

Syntax

ALTER MATERIALIZED VIEW QUALIFIEDNAME SET PROPERTIES PROPERTY_NAME=PROPERTY_VALUE;

Description

Modify the attributes of materialized views. For details about the attributes, see CREATE MATERIALIZED VIEW.

Example

Change the PROPERTIES attribute of the automatic refresh task submitted by the materialized view of mv.default.mv1mv.mvtestprop.pepa_ss to refresh_priority = 2.

Alter materialized view mv.mvtestprop.pepa_ss set PROPERTIES refresh_priority = 2;