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 9afa3cdb19 Optimized materialized view documentation (#12798) 9afa3cdb19 is described below commit 9afa3cdb1971a292603587104e78608bd911c33d Author: zy-kkk <zhong...@qq.com> AuthorDate: Mon Sep 26 12:25:20 2022 +0800 Optimized materialized view documentation (#12798) Optimized materialized view documentation --- .../Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md | 2 +- .../Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md index 643638870f..2c2a6036da 100644 --- a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md +++ b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md @@ -113,7 +113,7 @@ duplicate key (k1,k2,k3,k4) distributed BY hash(k4) buckets 3 properties("replication_num" = "1"); ``` -attention:The partition and distributed columns must be key column in mv +attention:If the materialized view contains partitioned and distributed columns of the Base table, these columns must be used as key columns in the materialized view 1. Create a materialized view that contains only the columns of the original table (k1, k2) diff --git a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md index 2b552930c7..aa0ae7ed1f 100644 --- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md +++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md @@ -113,7 +113,7 @@ duplicate key (k1,k2,k3,k4) distributed BY hash(k4) buckets 3 properties("replication_num" = "1"); ``` -注意:分区列和分桶列必须作为物化视图中的key列 +注意:如果物化视图包含了base表的分区列和分桶列,那么这些列必须作为物化视图中的key列 1. 创建一个仅包含原始表 (k1, k2)列的物化视图 --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org