Materialized View

Kind comparison

Causes

10 min triage

-- Sync MV status
SHOW ALTER TABLE MATERIALIZED VIEW FROM db;

-- Async MTMV status
SELECT * FROM mv_infos('database'='db') WHERE Name='mv'\G

-- Check rewrite eligibility
EXPLAIN VERBOSE SELECT ...;

-- Force refresh
REFRESH MATERIALIZED VIEW mv;

-- Enable external MV rewrite (for catalog queries)
SET materialized_view_rewrite_enable_contain_external_table = true;

Cause C — MTMV rewrite miss

Common reasons (see fe/.../mtmv/MTMVService.java rewrite matcher):

1. Partition misalignment: MV has partition_sync=false and query partition doesn't match → ALTER MATERIALIZED VIEW mv SET ("partition_sync" = "true")
2. Aggregation granularity: MV groups by (a, b) but query groups by (a) only → MV is not a valid rewrite target
3. Filter mismatch: MV WHERE clause doesn't cover query WHERE clause → check MV definition
4. Session var off: SET enable_materialized_view_rewrite = true

-- Debug: force the optimizer to log MV matching
SET enable_materialized_view_rewrite_debug_log = true;
EXPLAIN VERBOSE SELECT ...;  -- check fe/log/fe.audit.log for MV match details

Cause A — Sync MV stuck

-- Cancel stuck build
CANCEL ALTER TABLE MATERIALIZED VIEW FROM db ON table;

-- Check BE compaction queue (MV build competes with compaction)
./scripts/doris-debug be-metrics --be http://$BE:8040 --grep compaction

Source

• fe/.../mtmv/MTMVService.java — MTMV lifecycle
• fe/.../alter/MaterializedViewHandler.java — sync MV alter
• fe/.../materializedview/MaterializedViewRewriter.java — rewrite logic
• SessionVariable.java — enable_materialized_view_rewrite, materialized_view_rewrite_enable_contain_external_table