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-website.git
The following commit(s) were added to refs/heads/master by this push: new 4d7fad3c5f1 fix 4d7fad3c5f1 is described below commit 4d7fad3c5f132be57a4d8cd0274649576d7e4f1a Author: jiafeng.zhang <zhang...@gmail.com> AuthorDate: Tue Oct 11 14:57:39 2022 +0800 fix --- docs/advanced/alter-table/schema-change.md | 2 ++ .../Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md | 2 +- .../current/advanced/alter-table/schema-change.md | 2 ++ .../Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md | 2 +- 4 files changed, 6 insertions(+), 2 deletions(-) diff --git a/docs/advanced/alter-table/schema-change.md b/docs/advanced/alter-table/schema-change.md index 43488665a24..3e44bbb6ba8 100644 --- a/docs/advanced/alter-table/schema-change.md +++ b/docs/advanced/alter-table/schema-change.md @@ -175,6 +175,8 @@ At the same time, columns that already exist in the Base table are not allowed t Modifying the Key column of a table is done through the `key` keyword. Let's take a look at an example below. +**This usage is only for the key column of the duplicate key table** + Source Schema : ```text diff --git a/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md b/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md index 308ede9f649..a4c106523d7 100644 --- a/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md +++ b/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md @@ -215,7 +215,7 @@ ADD COLUMN v2 INT MAX DEFAULT "0" AFTER k2 TO example_rollup_index, ORDER BY (k3,k1,k2,v2,v1) FROM example_rollup_index; ``` -11. Modify the length of a field in the Key column +11. Modify the length of a field in the Key column of the Duplicate key table ```sql alter table example_tbl modify column k3 varchar(50) key null comment 'to 50' diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/alter-table/schema-change.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/alter-table/schema-change.md index bbf6614ff67..a9c3b867262 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/alter-table/schema-change.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/alter-table/schema-change.md @@ -185,6 +185,8 @@ ADD COLUMN k5 INT default "1" to rollup2; 修改表的 Key 列是通过 `key` 关键字完成,下面我们通过一个例子来看。 +**这个用法只针对 duplicate key 表的 key 列** + 源 Schema : ```text diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md index c796eb1feff..3f3e96db858 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md @@ -215,7 +215,7 @@ ADD COLUMN v2 INT MAX DEFAULT "0" AFTER k2 TO example_rollup_index, ORDER BY (k3,k1,k2,v2,v1) FROM example_rollup_index; ``` -11. 修改 Key 列的某个字段的长度 +11. 修改Duplicate key 表 Key 列的某个字段的长度 ```sql alter table example_tbl modify column k3 varchar(50) key null comment 'to 50' --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org