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

doris怎么增加多个分区?

Asked Feb 13 Modified Jan 1, 0001
Viewed 25
2.1

官网增加分区只有增加单个分区,ALTER TABLE example_db.my_table
ADD PARTITION p1 VALUES LESS THAN ("2014-01-01");
如果要增加多个分区怎么写

edited Jan 1, 0001
wakin7
asked Feb 13
1 Answers

你可以考虑下自动分区和动态分区
https://doris.apache.org/zh-CN/docs/table-design/data-partitioning/dynamic-partitioning
https://doris.apache.org/zh-CN/docs/table-design/data-partitioning/auto-partitioning

edited Jan 1, 1970
徐振超@SelectDB7056
answered Feb 13
Related Questions
请教一下如果从commit成功的checkpoint恢复时任务时会发生啥
doris2 列查询性能问题
2 answers
时间分区字段str_to_date格式不正确后直接全表扫描导致CPU飙升
1 answers
查询doris外部表分区存在穿刺情况
2.1.9报错:Fail to do ZSTD compress due to exception std
1 answers
flink读取doris中通过catalog配置的表报错

Terms of service Privacy policy

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