Updated on 2024-05-20 GMT+08:00

Support and Constraints

Supported Scenarios

  • Supports the same query scope as the CREATE TABLE AS statement does.
  • Supports index creation in complete-refresh materialized views.
  • Supports ANALYZE and EXPLAIN.

Unsupported Scenarios

Materialized views cannot be added, deleted, or modified. They support only query statements.

Constraints

When a complete-refresh materialized view is refreshed or deleted, a high-level lock is added to the base table. If the definition of a materialized view involves multiple tables, pay attention to the service logic to avoid deadlock.