Updated on 2024-06-07 GMT+08:00

Support and Constraints

Supported Scenarios

  • Generally, the query scope supported by complete-refresh materialized views is the same as that supported by the CREATE TABLE AS statement.
  • The distribution key can be specified when a complete-refresh materialized view is created.
  • Indexes can be created in a complete-refresh materialized view.
  • ANALYZE and EXPLAIN are supported.

Unsupported Scenarios

  • Full materialized views do not support node groups.
  • Materialized views cannot be added, deleted, or modified. Only query statements are supported.
  • Ustore does not support the creation and use of complete-refresh materialized views.

Constraints

  • The base table used to create a complete-refresh materialized view must be defined on all DNs, and the node group to which the base table belongs must be an installation group.
  • 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.