CREATE MATERIALIZED VIEW mview_saledata_cid_did
BUILD DEFERRED
REFRESH AUTO ON SCHEDULE EVERY 60 MINUTE
PARTITION BY (DATE_TRUNC(billdate, 'MONTH'))
DISTRIBUTED BY HASH (billdate) BUCKETS 2
PROPERTIES
("replication_num" = "1",
"excluded_trigger_tables" = "bas_account")
AS
select ... from a
inner join b on a.xx= b.xx
inner join c on a.xx = c.xx
inner joion d on c.xx = d.xx
union all
..... 有15个union all
我创建，视图创建时间超长，和刷新数据没有关系。看doris日志会有报错。
2026-05-25 13:08:57,779 WARN (mtmv-task-execute-1-thread-2|482) [CollectRelation.collectFromUnboundRelation():212] collect insert target table '[internal, erp_ql_test, mview_saledata_cid_did]' more than once.
2026-05-25 13:08:57,938 WARN (mtmv-task-execute-1-thread-2|482) [InitMaterializationContextHook.createAsyncMaterializationContext():198] MaterializationContext getAvailableMTMVs generate fail, current queryId is stmt[0, aff4068052d7477e-b19ac9698ac80e5c]
java.lang.UnsupportedOperationException
at com.google.common.collect.ImmutableCollection.add(ImmutableCollection.java:269)
at org.apache.doris.mtmv.MTMVPartitionUtil.isMTMVPartitionSync(MTMVPartitionUtil.java:106)
at org.apache.doris.mtmv.MTMVRewriteUtil.getMTMVCanRewritePartitions(MTMVRewriteUtil.java:99)
at org.apache.doris.mtmv.MTMVRelationManager.isMVPartitionValid(MTMVRelationManager.java:136)
at org.apache.doris.mtmv.MTMVRelationManager.getAvailableMTMVs(MTMVRelationManager.java:105)
at org.apache.doris.nereids.rules.exploration.mv.InitConsistentMaterializationContextHook.getAvailableMTMVs(InitConsistentMaterializationContextHook.java:50)
at org.apache.doris.nereids.rules.exploration.mv.InitMaterializationContextHook.createAsyncMaterializationContext(InitMaterializationContextHook.java:196)
at org.apache.doris.nereids.rules.exploration.mv.InitMaterializationContextHook.doInitMaterializationContext(InitMaterializationContextHook.java:124)
at org.apache.doris.nereids.rules.exploration.mv.InitConsistentMaterializationContextHook.initMaterializationContext(InitConsistentMaterializationContextHook.java:45)
at org.apache.doris.nereids.rules.exploration.mv.InitMaterializationContextHook.afterRewrite(InitMaterializationContextHook.java:83)
at org.apache.doris.nereids.NereidsPlanner.lambda$rewrite$6(NereidsPlanner.java:446)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at org.apache.doris.nereids.NereidsPlanner.rewrite(NereidsPlanner.java:446)
at org.apache.doris.nereids.trees.plans.commands.insert.FastInsertIntoValuesPlanner.rewrite(FastInsertIntoValuesPlanner.java:76)
at org.apache.doris.nereids.NereidsPlanner.planWithoutLock(NereidsPlanner.java:297)
at org.apache.doris.nereids.NereidsPlanner.planWithLock(NereidsPlanner.java:263)
at org.apache.doris.nereids.NereidsPlanner.plan(NereidsPlanner.java:162)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.planInsertExecutor(InsertIntoTableCommand.java:541)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlanOnce(InsertIntoTableCommand.java:351)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlan(InsertIntoTableCommand.java:259)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlan(InsertIntoTableCommand.java:226)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.runInternal(InsertIntoTableCommand.java:570)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.run(InsertIntoTableCommand.java:210)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.runInsertCommand(InsertOverwriteTableCommand.java:305)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.insertIntoPartitions(InsertOverwriteTableCommand.java:376)
at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.run(InsertOverwriteTableCommand.java:242)
at org.apache.doris.job.extensions.mtmv.MTMVTask.exec(MTMVTask.java:341)
at org.apache.doris.job.extensions.mtmv.MTMVTask.executeWithRetry(MTMVTask.java:292)
at org.apache.doris.job.extensions.mtmv.MTMVTask.run(MTMVTask.java:263)
at org.apache.doris.job.task.AbstractTask.runTask(AbstractTask.java:185)
at org.apache.doris.job.extensions.mtmv.MTMVTask.runTask(MTMVTask.java:482)
at org.apache.doris.job.executor.TaskProcessor.runTask(TaskProcessor.java:82)
at org.apache.doris.job.executor.TaskProcessor.lambda$addTask$0(TaskProcessor.java:48)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:840)
