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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
