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 89f180c47af [doc](mtmv) Add 3.1 external table rewrite notice (#2982)
89f180c47af is described below
commit 89f180c47afa4995a74978eabd7e2b30f3da3393
Author: seawinde <[email protected]>
AuthorDate: Wed Nov 26 16:36:48 2025 +0800
[doc](mtmv) Add 3.1 external table rewrite notice (#2982)
## Versions
- [x] dev
- [x] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../async-materialized-view/functions-and-demands.md | 14 ++++++++++++++
.../async-materialized-view/functions-and-demands.md | 5 +++++
.../async-materialized-view/functions-and-demands.md | 5 +++++
.../async-materialized-view/functions-and-demands.md | 15 +++++++++++++++
4 files changed, 39 insertions(+)
diff --git
a/docs/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
b/docs/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
index 1f1f41b2098..99bcbd4eb74 100644
---
a/docs/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
+++
b/docs/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
@@ -892,6 +892,20 @@ group by
```
+:::caution Notice
+Currently, partition compensation is supported, but compensation with
conditional UNION ALLis not yet available.
+
+For example, if a materialized view contains a WHEREclause—such as adding the
filter WHERE l_shipdate > '2023-10-19'in the example above—while
+the query condition is WHERE l_shipdate > '2023-10-18', this scenario
currently cannot be compensated via UNION ALL. Support for this case is planned
for a future release.
+:::
+
+:::info Note
+Starting from version 3.1.0
+The partition compensation rewrite feature supports the following types of
partitioned tables: internal tables, Hive, Iceberg, and Paimon.
+
+This means that the partition compensation mechanism can only be triggered
when a partitioned materialized view is built on partitioned tables of the
aforementioned types.
+:::
+
### Nested Materialized View Rewriting
The SQL definition of a materialized view can use another materialized view;
this is called a nested materialized view.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
index ae87ea53ee6..3773ceff7e1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
@@ -881,6 +881,11 @@ group by
比如，如果物化视图带有 `where` 条件，以上述为例，如果构建物化的过滤条件加上 ` WHERE l_shipdate >
'2023-10-19'`，而查询是 `WHERE l_shipdate > '2023-10-18'`，目前这种还无法通过 `UNION ALL`
补偿，待支持。
:::
+:::info 备注
+从 3.1.0 版本开始
+分区补偿改写功能支持以下类型的分区表：内表、Hive、Iceberg 与
Paimon。这意味着，仅当分区物化视图是基于上述类型的分区表构建时，才能触发分区补偿改写机制。
+:::
+
### 嵌套物化视图改写
物化视图的定义 SQL 可以使用物化视图，此物化视图称为嵌套物化视图。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
index 3b60e808ac1..822509c36b2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
@@ -881,6 +881,11 @@ group by
比如，如果物化视图带有 `where` 条件，以上述为例，如果构建物化的过滤条件加上 ` WHERE l_shipdate >
'2023-10-19'`，而查询是 `WHERE l_shipdate > '2023-10-18'`，目前这种还无法通过 `UNION ALL`
补偿，待支持。
:::
+:::info 备注
+从 3.1.0 版本开始
+分区补偿改写功能支持以下类型的分区表：内表、Hive、Iceberg 与
Paimon。这意味着，仅当分区物化视图是基于上述类型的分区表构建时，才能触发分区补偿改写机制。
+:::
+
### 嵌套物化视图改写
物化视图的定义 SQL 可以使用物化视图，此物化视图称为嵌套物化视图。
diff --git
a/versioned_docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
b/versioned_docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
index efa7fa14aa6..09b334319b3 100644
---
a/versioned_docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
+++
b/versioned_docs/version-3.x/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md
@@ -892,6 +892,21 @@ group by
```
+:::caution Notice
+Currently, partition compensation is supported, but compensation with
conditional UNION ALLis not yet available.
+
+For example, if a materialized view contains a WHEREclause—such as adding the
filter WHERE l_shipdate > '2023-10-19'in the example above—while
+the query condition is WHERE l_shipdate > '2023-10-18', this scenario
currently cannot be compensated via UNION ALL. Support for this case is planned
for a future release.
+:::
+
+:::info Note
+Starting from version 3.1.0
+The partition compensation rewrite feature supports the following types of
partitioned tables: internal tables, Hive, Iceberg, and Paimon.
+
+This means that the partition compensation mechanism can only be triggered
when a partitioned materialized view is built on partitioned tables of the
aforementioned types.
+:::
+
+
### Nested Materialized View Rewriting
The SQL definition of a materialized view can use another materialized view;
this is called a nested materialized view.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
