Apache Doris 中文技术论坛
Questions Tags Users Badges

2.0.13 执行 ALTRER COLOCATE GROUP 修改表副本数报错

Asked Apr 8, 2025 Modified Apr 8, 2025
Viewed 27
2.0

如题:我想缩减表的副本数,由于建表时指定了"colocate_with" = "xx_colocate_group",执行下面SQL时报错

ALTER COLOCATE GROUP xxdb.xx_colocate_group
SET (
    "replication_allocation"="tag.location.default:1"
);

下面的也不行

ALTER COLOCATE GROUP xx_db.xx_colocate_group
   SET (
       "replication_num"="1"
   );

image.png

文档链接是参考下面:
https://doris.apache.org/zh-CN/docs/2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-COLOCATE-GROUP?_highlight=colocate&_highlight=group

edited Apr 8, 2025
danvid5
asked Apr 8, 2025
1 Answers

应该是当前版本语法还不兼容导致,看能否先重建下的

edited Jan 1, 1970
张彬华7698
answered Apr 8, 2025
Related Questions
doris2.0.7集群迁移到新搭建的doris2.1.11集群
1 answers
Alter routine load后参数变动
1 answers
Doris Routine Load重置offset
1 answers
我的doris版本为2.0.6 在备份操作时,会导致所以fe节点宕机,这种情况该怎么排查,为什么备份会导致这个问题?
1 answers
Doris Routine Load自动恢复机制
1 answers
Doris 2.0.15,3FE、6BE(3BE mix角色 3BE computation角色)3个mix角色的BE节点CPU使用率100%
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.