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

Doris2.0版本如何【复制表的时候能够保证数据模型不发生改变】

Asked Oct 30, 2024 Modified Jan 1, 0001
Viewed 37
storage 2.0

在Doris中例如:
CREATE TABLE Table_backup AS SELECT * FROM Table;

Table是主键模型,但是我发现我复制后的表Table_backup变成了明细模型。有什么好的建议吗?

edited Jan 1, 0001
yckonnnnnn11
asked Oct 30, 2024
1 Answers

可以在create table as的时候另外指定表模型、分区、分桶,具体可以参考:CREATE-TABLE-AS-SELECT

edited Jan 1, 1970
张彬华7678
answered Oct 30, 2024
Related Questions
异步物化视图刷新时会锁表吗
1 answers
doris2.0.15 unique表部分更新出现副本数据不一致
1 answers
最近生产环境Be 节点总是全部同时宕机!!!求大佬帮忙看看啊
2 answers
异步物化视图某一时刻RreshState为fail,对最终数据正确性是否有影响
1 answers
磁盘分布不均匀
2 answers
Doris2.0.11版本恢复备份时报错
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 中文技术论坛.