菜单
Use for Doris sync MV (rollup) miss or async MTMV refresh/rewrite issues. Commands: SHOW ALTER TABLE MATERIALIZED VIEW, mv_infos(), EXPLAIN, REFRESH MATERIALIZED VIEW.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/apache/doris-skills --skill doris-debug-materialized-view命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
基于 SOC 职业分类
正在显示 SKILL.md
| name | doris-debug-materialized-view |
| description | Use for Doris sync MV (rollup) miss or async MTMV refresh/rewrite issues. Commands: SHOW ALTER TABLE MATERIALIZED VIEW, mv_infos(), EXPLAIN, REFRESH MATERIALIZED VIEW. |
| version | 0.2.0 |
| category | materialized-view |
| 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 |
| 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 |
-- 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;
Common reasons (see fe/.../mtmv/MTMVService.java rewrite matcher):
partition_sync=false and query partition doesn't match → ALTER MATERIALIZED VIEW mv SET ("partition_sync" = "true")(a, b) but query groups by (a) only → MV is not a valid rewrite targetSET 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
-- 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
fe/.../mtmv/MTMVService.java — MTMV lifecyclefe/.../alter/MaterializedViewHandler.java — sync MV alterfe/.../materializedview/MaterializedViewRewriter.java — rewrite logicSessionVariable.java — enable_materialized_view_rewrite, materialized_view_rewrite_enable_contain_external_table