HomeMogDBMogDB StackUqbar
v3.0

Documentation:v3.0

Supported Versions:

Other Versions:

REFRESH INCREMENTAL MATERIALIZED VIEW

Function

REFRESH INCREMENTAL MATERIALIZED VIEW refreshes the materialized view in materialized mode.

Precautions

  • Incremental refresh supports only fast-refresh materialized views.
  • To refresh a materialized view, you must have the SELECT permission on the base table.

Syntax

RefreshIncrementalMaterializedView ::= REFRESH INCREMENTAL MATERIALIZED VIEW mv_name;

Parameter Description

  • mv_name

    Name of the materialized view to be refreshed.

Example

-- Create an ordinary table.
MogDB=# CREATE TABLE my_table (c1 int, c2 int);
-- Create an fast-refresh materialized view.
MogDB=# CREATE INCREMENTAL MATERIALIZED VIEW my_imv AS SELECT * FROM my_table;
-- Write data to the base table.
MogDB=# INSERT INTO my_table VALUES(1,1),(2,2);
-- Incrementally refresh the fast-refresh materialized view my_imv.
MogDB=# REFRESH INCREMENTAL MATERIALIZED VIEW my_imv;

ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW, and REFRESH MATERIALIZED VIEW

Copyright © 2011-2024 www.enmotech.com All rights reserved.