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

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

Asked Apr 8, 2025 Modified Apr 8, 2025
Viewed 22
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
各位大哥在通过k8s安装doris3.0的时候,有没有遇到cg启动不起来,提示Set max number of open file descriptors to a value greater than 60000.
1 answers
doris2.0.2.1大量delete语句和stream load执行在5分钟左右
1 answers
doris主键表可以bucket配置太小,怎么修改?
1 answers
flink-doris-connector-1.20.24.0.0 2pc ,checkpoint处恢复数据重复
1 answers
Doris的json解析问题
1 answers
EXPORT 导出cvs 数据为空 导出为\N 怎么修改这个设置
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 中文技术论坛.