This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 7085fa870e5 (mtmv) Fix create materialized view err on branch 21
(#2217)
7085fa870e5 is described below
commit 7085fa870e56f62dfbe6057f9fcda528a874f41c
Author: seawinde <[email protected]>
AuthorDate: Fri Aug 1 10:57:40 2025 +0800
(mtmv) Fix create materialized view err on branch 21 (#2217)
---
.../functions-and-demands.md | 46 ++++++++++--------
.../functions-and-demands.md | 56 ++++++++++++----------
2 files changed, 57 insertions(+), 45 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
index d4066a30efe..f405071f613 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
@@ -90,22 +90,25 @@ CREATE MATERIALIZED VIEW
如下，要求全量刷新 (`REFRESH COMPLETE`)，物化视图每 10 小时刷新一次，并且刷新物化视图的所有分区。
- ```sql
- CREATE MATERIALIZED VIEW mv_6
- REFRESH COMPLETE ON SCHEDULE EVERY 10 hour
- AS
- SELECT * FROM lineitem;
- ```
+
+```sql
+CREATE MATERIALIZED VIEW mv_6
+REFRESH COMPLETE ON SCHEDULE EVERY 10 hour
+DISTRIBUTED BY RANDOM BUCKETS 2
+AS
+SELECT * FROM lineitem;
+```
如下，尽量增量刷新 (`REFRESH AUTO`)，只刷新自上次物化刷新后数据变化的分区，如果不能增量刷新，就刷新所有分区，物化视图每 10
小时刷新一次（从 2.1.3 版本开始能自动计算 Hive 需要刷新的分区）。
- ```sql
- CREATE MATERIALIZED VIEW mv_7
- REFRESH AUTO ON SCHEDULE EVERY 10 hour
- PARTITION by(l_shipdate)
- AS
- SELECT * FROM lineitem;
- ```
+```sql
+CREATE MATERIALIZED VIEW mv_7
+REFRESH AUTO ON SCHEDULE EVERY 10 hour
+PARTITION by(l_shipdate)
+DISTRIBUTED BY RANDOM BUCKETS 2
+AS
+SELECT * FROM lineitem;
+```
- **`ON COMMIT` 自动触发**
@@ -117,13 +120,14 @@ CREATE MATERIALIZED VIEW
如果物化视图的创建语句如下，那么当 基表 `lineitem` 的 `t1` 分区数据发生变化时，会自动触发物化视图的对应分区刷新。
- ```sql
- CREATE MATERIALIZED VIEW mv_8
- REFRESH AUTO ON COMMIT
- PARTITION by(l_shipdate)
- AS
- SELECT * FROM lineitem;
- ```
+```sql
+CREATE MATERIALIZED VIEW mv_8
+REFRESH AUTO ON COMMIT
+PARTITION by(l_shipdate)
+DISTRIBUTED BY RANDOM BUCKETS 2
+AS
+SELECT * FROM lineitem;
+```
:::caution 注意
如果基表的数据频繁变更，不太适合使用此种触发方式，因为会频繁构建物化刷新任务，消耗过多资源。
@@ -237,6 +241,7 @@ CREATE MATERIALIZED VIEW mv_1_1
BUILD DEFERRED
REFRESH COMPLETE
ON SCHEDULE EVERY 1 DAY STARTS '2024-12-01 20:30:00'
+DISTRIBUTED BY RANDOM BUCKETS 2
PROPERTIES ('replication_num' = '1')
AS
SELECT
@@ -258,6 +263,7 @@ CREATE MATERIALIZED VIEW mv_1_1
BUILD IMMEDIATE
REFRESH COMPLETE
ON COMMIT
+DISTRIBUTED BY RANDOM BUCKETS 2
PROPERTIES ('replication_num' = '1')
AS
SELECT
diff --git
a/versioned_docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
b/versioned_docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
index e8b03fce533..a037b30a359 100644
---
a/versioned_docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
+++
b/versioned_docs/version-2.1/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
@@ -93,24 +93,26 @@ Determines whether to refresh immediately after
materialized view creation.
Example of full refresh (`REFRESH COMPLETE`) every 10 hours, refreshing all
partitions:
- ```sql
- CREATE MATERIALIZED VIEW mv_6
- REFRESH COMPLETE ON SCHEDULE EVERY 10 hour
- AS
- SELECT FROM lineitem;
- ```
+```sql
+CREATE MATERIALIZED VIEW mv_6
+REFRESH COMPLETE ON SCHEDULE EVERY 10 hour
+DISTRIBUTED BY RANDOM BUCKETS 2
+AS
+SELECT FROM lineitem;
+```
Example of incremental refresh (`REFRESH AUTO`) every 10 hours,
only refreshing changed partitions or falling back to full refresh if needed
(automatic Hive partition calculation supported from version 2.1.3):
- ```sql
- CREATE MATERIALIZED VIEW mv_7
- REFRESH AUTO ON SCHEDULE EVERY 10 hour
- PARTITION by(l_shipdate)
- AS
- SELECT FROM lineitem;
- ```
+```sql
+CREATE MATERIALIZED VIEW mv_7
+REFRESH AUTO ON SCHEDULE EVERY 10 hour
+PARTITION by(l_shipdate)
+DISTRIBUTED BY RANDOM BUCKETS 2
+AS
+SELECT FROM lineitem;
+```
- **`ON COMMIT` Automatic Trigger**
@@ -123,17 +125,19 @@ Determines whether to refresh immediately after
materialized view creation.
Example: When partition `t1` data changes in base table `lineitem`, it
automatically triggers corresponding materialized view partition refresh:
- ```sql
- CREATE MATERIALIZED VIEW mv_8
- REFRESH AUTO ON COMMIT
- PARTITION by(l_shipdate)
- AS
- SELECT FROM lineitem;
- ```
-
- :::caution
- Not recommended for frequently changing base tables as it creates frequent
materialized refresh tasks, consuming excessive resources.
- :::
+```sql
+CREATE MATERIALIZED VIEW mv_8
+REFRESH AUTO ON COMMIT
+PARTITION by(l_shipdate)
+DISTRIBUTED BY RANDOM BUCKETS 2
+AS
+SELECT FROM lineitem;
+```
+
+
+:::caution
+Not recommended for frequently changing base tables as it creates frequent
materialized refresh tasks, consuming excessive resources.
+:::
For more details, see [REFRESH MATERIALIZED
VIEW](../../../sql-manual/sql-statements/table-and-view/async-materialized-view/REFRESH-MATERIALIZED-VIEW)
@@ -240,7 +244,8 @@ The time specified in STARTS must be later than the current
time.
CREATE MATERIALIZED VIEW mv_1_1
BUILD DEFERRED
REFRESH COMPLETE
-ON SCHEDULE EVERY 1 DAY STARTS '2024-12-01 20:30:00'
+ON SCHEDULE EVERY 1 DAY STARTS '2024-12-01 20:30:00'
+DISTRIBUTED BY RANDOM BUCKETS 2
AS
SELECT
l_linestatus,
@@ -260,6 +265,7 @@ CREATE MATERIALIZED VIEW mv_1_1
BUILD IMMEDIATE
REFRESH COMPLETE
ON COMMIT
+DISTRIBUTED BY RANDOM BUCKETS 2
AS
SELECT
l_linestatus,
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
