doris-debug-materialized-view
Installation
SKILL.md
Materialized View
Kind comparison
| Kind | Code area | Check | Rewrite mechanism |
|---|---|---|---|
| Sync | MaterializedViewHandler / rollup |
SHOW ALTER TABLE MATERIALIZED VIEW |
Transparent — planner auto-selects |
| Async MTMV | fe/.../mtmv/ |
mv_infos() RefreshState |
CBO-based — EXPLAIN shows if matched |
Causes
| ID | Cause | Evidence | Kind |
|---|---|---|---|
| A | Sync MV build pending/stuck | SHOW ALTER TABLE MATERIALIZED VIEW State≠FINISHED |
Sync |
| B | MTMV refresh failed | mv_infos() RefreshState=FAIL |
Async |
| C | MTMV rewrite miss | EXPLAIN shows no MATERIALIZED_REWRITE | Async |
| D | MTMV data stale | mv_infos() LastRefreshTime old |
Async |
| E | MV not selected by planner | EXPLAIN shows TABLE SCAN not MATERIALIZED | Either |