Skip to main content
Skip to main content

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))
| REPLACE WITH MATERIALIZED VIEW newName=identifier propertyClause?
| (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");
REPLACE​
ALTER MATERIALIZED VIEW [db.]mv1 REPLACE WITH MATERIALIZED VIEW mv2
[PROPERTIES('swap' = 'true')];

Replacing atoms with two materialized views

swap default is TRUE

  • If the swap parameter is set to TRUE, it is equivalent to renaming the materialized view mv1 to mv2, and renaming mv2 to mv1 at the same time
  • If the swap parameter is set to FALSE, it is equivalent to renaming mv2 to mv1 and deleting the original mv1

For example, if you want to swap the names of mv1 and mv2

ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2;

For example, if you want to rename mv2 to mv1 and delete the original mv1

ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2
PROPERTIES('swap' = 'false');

Keywords​

ALTER, ASYNC, MATERIALIZED, VIEW