KassieZ commented on code in PR #1240: URL: https://github.com/apache/doris-website/pull/1240#discussion_r1820434281
########## i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/schema-change.md: ########## @@ -97,31 +97,71 @@ ALTER TABLE table_name ADD COLUMN column_name column_type [KEY | agg_type] [DEFA ### 示例 -**1. 向 `example_rollup_index ` 的 col1 后添加一个 Key 列 `new_col` (非聚合模型)** +#### 非聚合模型 + +建表语句： +```sql +CREATE TABLE IF NOT EXISTS example_db.my_table( + col1 int, + col2 int, + col3 int, + col4 int, + col5 int +) DUPLICATE KEY(col1, col2, col3) +DISTRIBUTED BY RANDOM BUCKETS 1 +ROLLUP ( + example_rollup_index (col1, col3, col4, col5) +) +PROPERTIES ( + "replication_num" = "1" +) +``` + +**1. 向 `example_rollup_index ` 的 col1 后添加一个 Key 列 `new_col`** ```sql ALTER TABLE example_db.my_table ADD COLUMN new_col INT KEY DEFAULT "0" AFTER col1 TO example_rollup_index; ``` -**2. 向 `example_rollup_index` 的 col1 后添加一个 Value 列 `new_col` (非聚合模型)** +**2. 向 `example_rollup_index` 的 col1 后添加一个 Value 列 `new_col`** ```sql ALTER TABLE example_db.my_table ADD COLUMN new_col INT DEFAULT "0" AFTER col1 TO example_rollup_index; ``` -**3. 向 `example_rollup_index` 的 col1 后添加一个 Key 列 `new_col` (聚合模型)** +#### 聚合模型 Review Comment: `**聚合模型**` ########## i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/schema-change.md: ########## @@ -261,6 +318,24 @@ ALTER TABLE table_name ORDER BY (column_name1, column_name2, ...) ### 示例 Review Comment: 示例 1 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
