This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new d0e906f329 [Docs](alter partition) Fix the docs of adding default
partition (#23705)
d0e906f329 is described below
commit d0e906f329578b5122b45e7780210fa227af1f6c
Author: bobhan1 <[email protected]>
AuthorDate: Fri Sep 1 00:20:12 2023 +0800
[Docs](alter partition) Fix the docs of adding default partition (#23705)
according to https://github.com/apache/doris/pull/15509, add a default list
partition don't need the keyword `DEFAULT`
---
.../Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md | 4 ++--
.../Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md | 4 ++--
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
index d1774fcf47..03aa6968ea 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
@@ -64,8 +64,8 @@ Notice:
- If the bucketing method is specified, only the number of buckets can be
modified, not the bucketing method or the bucketing column. If the bucketing
method is specified but the number of buckets not be specified, the default
value `10` will be used for bucket number instead of the number specified when
the table is created. If the number of buckets modified, the bucketing method
needs to be specified simultaneously.
- The ["key"="value"] section can set some attributes of the partition, see
[CREATE TABLE](../Create/CREATE-TABLE.md)
- If the user does not explicitly create a partition when creating a table,
adding a partition by ALTER is not supported
-- If the user uses list partition then they can add default partition to the
table
- - ALTER TABLE ADD PARTITION DEFAULT
+- If the user uses list partition then they can add default partition to the
table. The default partition will store all data not satisfying prior partition
key's constraints.
+ - ALTER TABLE table_name ADD PARTITION partition_name
2. Delete the partition
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
index 43987d00e5..c9ea4a4c7d 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-PARTITION.md
@@ -64,8 +64,8 @@ partition_desc ["key"="value"]
-
如指定分桶方式，只能修改分桶数，不可修改分桶方式或分桶列。如果指定了分桶方式，但是没有指定分桶数，则分桶数会使用默认值10，不会使用建表时指定的分桶数。如果要指定分桶数，则必须指定分桶方式。
- ["key"="value"] 部分可以设置分区的一些属性，具体说明见 [CREATE TABLE](../Create/CREATE-TABLE.md)
- 如果建表时用户未显式创建Partition,则不支持通过ALTER的方式增加分区
-- 如果用户使用的是List Partition则可以增加default partition
- - ALTER TABLE ADD PARTITION DEFAULT
+- 如果用户使用的是List Partition则可以增加default partition，default
partition将会存储所有不满足其他分区键要求的数据。
+ - ALTER TABLE table_name ADD PARTITION partition_name
2. 删除分区
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
