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

Support and Constraints

Supported Scenarios

  • Supports statements for querying a single table.
  • Supports UNION ALL for querying multiple single tables.
  • Supports index creation in materialized views.
  • Supports the ANALYZE operation in materialized views.

Unsupported Scenarios

  • Multi-table join plans and subquery plans are not supported in materialized views.
  • Except for a few ALTER operations, most DDL operations cannot be performed on base tables in materialized views.
  • Materialized views cannot be added, deleted, or modified. They support only query statements.
  • Temporary, hash bucket, unlogged, or partitioned tables cannot be used to create materialized views.
  • Materialized views cannot be created in nested mode (that is, a materialized view cannot be created in another materialized view).
  • Materialized views of the UNLOGGED type are not supported, and the WITH syntax is not supported.
  • Ustore does not support the creation and use of fast-refresh materialized views.

Constraints

  • If the materialized view definition is UNION ALL, each subquery needs to use a different base table.
  • When a fast-refresh materialized view is created, completely refreshed, or deleted, a high-level lock is added to the base table. If the materialized view is defined as UNION ALL, pay attention to the service logic to avoid deadlock.