This is an automated email from the ASF dual-hosted git repository.
jiafengzheng 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 bd4f994c7e update document of alter table oartition (#12077)
bd4f994c7e is described below
commit bd4f994c7e32d4c3518e804d4db92e2cfd190305
Author: weizuo93 <[email protected]>
AuthorDate: Sat Aug 27 10:08:13 2022 +0800
update document of alter table oartition (#12077)
update document of alter table oartition
---
.../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 79f7b53de9..8538352a06 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
@@ -60,8 +60,8 @@ Notice:
- VALUES LESS THAN [MAXVALUE|("value1", ...)]
- VALUES [("value1", ...), ("value1", ...))
- The partition is left closed and right open. If the user only specifies the
right boundary, the system will automatically determine the left boundary
-- If the bucketing method is not specified, the bucketing method used for
creating the table is automatically used
-- 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 not specified, the bucketing method and bucket
number used for creating the table would be automatically used
+- 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](./sql-manual/sql-reference/Data-Definition-Statements/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
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 975e80670a..33776d02ad 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
@@ -60,8 +60,8 @@ partition_desc ["key"="value"]
- VALUES LESS THAN [MAXVALUE|("value1", ...)]
- VALUES [("value1", ...), ("value1", ...))
- 分区为左闭右开区间,如果用户仅指定右边界,系统会自动确定左边界
-- 如果没有指定分桶方式,则自动使用建表使用的分桶方式
-- 如指定分桶方式,只能修改分桶数,不可修改分桶方式或分桶列
+- 如果没有指定分桶方式,则自动使用建表使用的分桶方式和分桶数。
+-
如指定分桶方式,只能修改分桶数,不可修改分桶方式或分桶列。如果指定了分桶方式,但是没有指定分桶数,则分桶数会使用默认值10,不会使用建表时指定的分桶数。如果要指定分桶数,则必须指定分桶方式。
- ["key"="value"] 部分可以设置分区的一些属性,具体说明见 [CREATE
TABLE](./sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md)
- 如果建表时用户未显式创建Partition,则不支持通过ALTER的方式增加分区
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]