ALTER-ASYNC-MATERIALIZED-VIEW

ALTER-ASYNC-MATERIALIZED-VIEW

Name

ALTER ASYNC MATERIALIZED VIEW

Description

This statement is used to modify asynchronous materialized views.

syntax

ALTER MATERIALIZED VIEW mvName=multipartIdentifier ((RENAME newName=identifier)
       | (REFRESH (refreshMethod | refreshTrigger | refreshMethod refreshTrigger))
       | (SET  LEFT_PAREN fileProperties=propertyItemList RIGHT_PAREN))

illustrate

RENAME

Used to change the name of the materialized view

For example, changing the name of mv1 to mv2

ALTER MATERIALIZED VIEW mv1 rename mv2;

refreshMethod

Same as creating asynchronous materialized views

refreshTrigger

Same as creating asynchronous materialized views

SET

Modify properties unique to materialized views

For example, modifying the grace_period of mv1 to 3000ms

ALTER MATERIALIZED VIEW mv1 set("grace_period"="3000");

Keywords

ALTER, ASYNC, MATERIALIZED, VIEW