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

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

Asked Apr 8 Modified Apr 8
Viewed 21
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
danvid5
asked Apr 8
1 Answers

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

edited Jan 1, 1970
张彬华7688
answered Apr 8
Related Questions
storage policy删除以后,日志一直报could not find storage_policy
1 answers
doris 使用catalog外部数据hive, 在切换库时 特别阻塞时间长,应该如何排查
1 answers
doris 没隔一段时间生成的image ,不停缓慢增长,已经有7个多G了
2 answers
delete bitmap问题
1 answers
升级后 SSL connection required for plugin "mysql_clear_password". Check if 'sslMode' is enabled.
DorisBE节点global类型中Orphan占用内存高
1 answers

Terms of service Privacy policy

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