You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2022/02/17 02:53:15 UTC
[incubator-doris] branch master updated: [doc] update alter table docs (#8076)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new d9535c2 [doc] update alter table docs (#8076)
d9535c2 is described below
commit d9535c29f6fa93280b1dde9ec071a590c49eb051
Author: GRX <25...@qq.com>
AuthorDate: Thu Feb 17 10:52:59 2022 +0800
[doc] update alter table docs (#8076)
---
docs/en/sql-reference/sql-statements/Data Definition/ALTER TABLE.md | 5 ++++-
.../sql-reference/sql-statements/Data Definition/ALTER TABLE.md | 3 +++
2 files changed, 7 insertions(+), 1 deletion(-)
diff --git a/docs/en/sql-reference/sql-statements/Data Definition/ALTER TABLE.md b/docs/en/sql-reference/sql-statements/Data Definition/ALTER TABLE.md
index 6e7c901..2df6a15 100644
--- a/docs/en/sql-reference/sql-statements/Data Definition/ALTER TABLE.md
+++ b/docs/en/sql-reference/sql-statements/Data Definition/ALTER TABLE.md
@@ -54,6 +54,7 @@ under the License.
2) If the bucket mode is not specified, the bucket method used by the built-in table is automatically used.
3) If the bucket mode is specified, only the bucket number can be modified, and the bucket mode or bucket column cannot be modified.
4) ["key"="value"] section can set some properties of the partition, see CREATE TABLE for details.
+ 5) Adding partitions to non-partitioned table is not supported.
2. Delete the partition
grammar:
@@ -376,9 +377,11 @@ under the License.
ALTER TABLE example_db.my_table set ("dynamic_partition.enable" = "false");
- If you need to add dynamic partition attributes to a table without dynamic partition attributes, you need to specify all dynamic partition attributes
+ If you need to add dynamic partition attributes to a table without dynamic partition attributes, you need to specify all dynamic partition attributes.
+ (Note:Adding dynamic partition attributes to non-partitioned table is not supported)
ALTER TABLE example_db.my_table set ("dynamic_partition.enable"= "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.end "= "3", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "32");
+
15. Modify the in_memory property of the table
diff --git a/docs/zh-CN/sql-reference/sql-statements/Data Definition/ALTER TABLE.md b/docs/zh-CN/sql-reference/sql-statements/Data Definition/ALTER TABLE.md
index 1746d2c..1738b1a 100644
--- a/docs/zh-CN/sql-reference/sql-statements/Data Definition/ALTER TABLE.md
+++ b/docs/zh-CN/sql-reference/sql-statements/Data Definition/ALTER TABLE.md
@@ -54,6 +54,7 @@ under the License.
2) 如果没有指定分桶方式，则自动使用建表使用的分桶方式
3) 如指定分桶方式，只能修改分桶数，不可修改分桶方式或分桶列
4) ["key"="value"] 部分可以设置分区的一些属性，具体说明见 CREATE TABLE
+ 5) 如果建表时用户未显式创建Partition,则不支持通过ALTER的方式增加分区
2. 删除分区
语法：
@@ -376,7 +377,9 @@ under the License.
ALTER TABLE example_db.my_table set ("dynamic_partition.enable" = "false");
如果需要在未添加动态分区属性的表中添加动态分区属性，则需要指定所有的动态分区属性
+ (注:非分区表不支持添加动态分区属性)
ALTER TABLE example_db.my_table set ("dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "32");
+
15. 修改表的 in_memory 属性
ALTER TABLE example_db.my_table set ("in_memory" = "true");
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org