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

Reply via email to