【StarRocks版本】例如：2.5.4
【详述】多表关联创建分区物化视图失败
报错：
ERROR_MESSAGE: com.starrocks.sql.common.DmlException: materialized view:g_measure_view_2_test refresh task failed
Fe日志：
2023-04-24 17:03:54,244 INFO (pool-20-thread-22|101596) [PartitionBasedMaterializedViewRefreshProcessor.processTaskRun():149] materialized view:g_measure_view_2_test base partition has changed. retry to sync partitions, retryNum:10
2023-04-24 17:03:54,430 INFO (pool-20-thread-22|101596) [PartitionBasedMaterializedViewRefreshProcessor.syncPartitionsForExpr():437] The process of synchronizing materialized view [g_measure_view_2_test] delete partitions range [{}]
2023-04-24 17:03:54,430 INFO (pool-20-thread-22|101596) [PartitionBasedMaterializedViewRefreshProcessor.syncPartitionsForExpr():449] The process of synchronizing materialized view [g_measure_view_2_test] add partitions range [{}]
2023-04-24 17:04:01,004 INFO (starrocks-mysql-nio-pool-116|102477) [QeProcessorImpl.registerQuery():81] register query id = f43f4fff-e27e-11ed-a495-86e6dd860eb7, job: -1
2023-04-24 17:04:01,021 INFO (starrocks-mysql-nio-pool-116|102477) [QeProcessorImpl.unregisterQuery():91] deregister query id f43f4fff-e27e-11ed-a495-86e6dd860eb7
2023-04-24 17:04:01,021 INFO (thrift-server-pool-665|102486) [QeProcessorImpl.reportExecStatus():130] ReportExecStatus() failed, query does not exist, fragment_instance_id=f43f4fff-e27e-11ed-a495-86e6dd860eb9, query_id=f43f4fff-e27e-11
ed-a495-86e6dd860eb7,
2023-04-24 17:04:01,021 INFO (thrift-server-pool-664|102485) [QeProcessorImpl.reportExecStatus():130] ReportExecStatus() failed, query does not exist, fragment_instance_id=f43f4fff-e27e-11ed-a495-86e6dd860eb8, query_id=f43f4fff-e27e-11
ed-a495-86e6dd860eb7,
2023-04-24 17:04:01,708 WARN (pool-20-thread-22|101596) [PartitionBasedMaterializedViewRefreshProcessor.checkBaseTablePartitionChange():789] Materialized view compute partition change failed
com.starrocks.common.AnalysisException: Materialized view partition column in partition exp must be base table partition column
at com.starrocks.connector.PartitionUtil.checkAndGetPartitionColumnIndex(PartitionUtil.java:235) ~[starrocks-fe.jar:?]
at com.starrocks.connector.PartitionUtil.getMVPartitionNameWithRange(PartitionUtil.java:289) ~[starrocks-fe.jar:?]
at com.starrocks.connector.PartitionUtil.getPartitionRange(PartitionUtil.java:218) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.PartitionBasedMaterializedViewRefreshProcessor.checkBaseTablePartitionChange(PartitionBasedMaterializedViewRefreshProcessor.java:748) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.PartitionBasedMaterializedViewRefreshProcessor.processTaskRun(PartitionBasedMaterializedViewRefreshProcessor.java:144) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.TaskRun.executeTaskRun(TaskRun.java:124) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.TaskRunExecutor.lambda$executeTaskRun$0(TaskRunExecutor.java:34) ~[starrocks-fe.jar:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604) [?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_362]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_362]
2023-04-24 17:04:01,709 WARN (pool-20-thread-22|101596) [TaskRunExecutor.lambda$executeTaskRun$0():41] failed to execute TaskRun.
com.starrocks.sql.common.DmlException: materialized view:g_measure_view_2_test refresh task failed
at com.starrocks.scheduler.PartitionBasedMaterializedViewRefreshProcessor.processTaskRun(PartitionBasedMaterializedViewRefreshProcessor.java:147) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.TaskRun.executeTaskRun(TaskRun.java:124) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.TaskRunExecutor.lambda$executeTaskRun$0(TaskRunExecutor.java:34) ~[starrocks-fe.jar:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604) [?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_362]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_362]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_362]
建表语句.txt (2.7 KB) 物化视图创建语句.txt (1.5 KB)