starrocks 跨集群数据迁移同步报错
源集群版本:2.5.8
目标集群版本:3.2.9
异常报错日志:ERROR [ddl-handler] execDDLJob(Utils.java:191): Failed to execute ALTER TABLE ads
.ads_book_xxxxx_attribution_xxxx_xx
SET(“dynamic_partition.enable” = “true”) of ads on the TARGET cluster.
java.sql.SQLSyntaxErrorException: Unexpected exception: A schema change operation is in progress on the table “ads_book_xxxxx_attribution_xxxx_xx”. Please wait until the current operation completes.
问题:源库ads_book_xxxxx_attribution_xxxx_xx表默认开始动态分区,目标集群同步建表关闭动态分区,尝试开启目标集群动态分区失败。
SQL语句:ALTER TABLE ads_book_xxxxx_attribution_xxxx_xx SET(“dynamic_partition.enable”=“true”);