This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 5ea8886da442 [doc](mtmv) Support more join types for query rewriting
by materialized view (#458)
5ea8886da442 is described below
commit 5ea8886da442452260e86925a607cb6a4e4e06bb
Author: seawinde <149132972+seawi...@users.noreply.github.com>
AuthorDate: Mon Mar 25 10:55:09 2024 +0800
[doc](mtmv) Support more join types for query rewriting by materialized
view (#458)
---
.../async-materialized-view/query-async-materialized-view.md | 12 ++++++++++--
.../async-materialized-view/query-async-materialized-view.md | 10 +++++++++-
.../async-materialized-view/query-async-materialized-view.md | 10 +++++++++-
.../async-materialized-view/query-async-materialized-view.md | 12 ++++++++++--
4 files changed, 38 insertions(+), 6 deletions(-)
diff --git
a/docs/query-acceleration/async-materialized-view/query-async-materialized-view.md
b/docs/query-acceleration/async-materialized-view/query-async-materialized-view.md
index 2d166fe0f3ec..84020ed436c3 100644
---
a/docs/query-acceleration/async-materialized-view/query-async-materialized-view.md
+++
b/docs/query-acceleration/async-materialized-view/query-async-materialized-view.md
@@ -151,8 +151,16 @@ Join rewriting refers to when the tables used in the query
and the materializati
In this case, the optimizer will attempt transparent rewriting by either
joining the input of the materialized
view with the query or placing the join in the outer layer of the query's
WHERE clause.
-This pattern of rewriting is supported for multi-table joins and supports
inner and left join types.
-Support for other types is continually expanding.
+This pattern of rewriting is supported for multi-table joins and supported
join types is as following:
+
+* INNER JOIN
+* LEFT OUTER JOIN
+* RIGHT OUTER JOIN
+* FULL OUTER JOIN
+* LEFT SEMI JOIN
+* RIGHT SEMI JOIN
+* LEFT ANTI JOIN
+* RIGHT ANTI JOIN
**Case 1:**
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/async-materialized-view/query-async-materialized-view.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/async-materialized-view/query-async-materialized-view.md
index 0496303c909d..efac212a2cc1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/async-materialized-view/query-async-materialized-view.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/async-materialized-view/query-async-materialized-view.md
@@ -144,7 +144,15 @@ WHERE l_linenumber > 1 and o_orderdate = '2023-10-18';
### JOIN 改写
Join 改写指的是查询和物化使用的表相同，可以在物化视图和查询 Join 的输入或者 Join 的外层写 where，优化器对此 pattern
的查询会尝试进行透明改写。
-支持多表 Join，支持 Join 的类型为 inner，left。其他类型在不断拓展中。
+支持多表 Join，支持 Join 的类型为:
+* INNER JOIN
+* LEFT OUTER JOIN
+* RIGHT OUTER JOIN
+* FULL OUTER JOIN
+* LEFT SEMI JOIN
+* RIGHT SEMI JOIN
+* LEFT ANTI JOIN
+* RIGHT ANTI JOIN
**用例1:**
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
index 0496303c909d..efac212a2cc1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
@@ -144,7 +144,15 @@ WHERE l_linenumber > 1 and o_orderdate = '2023-10-18';
### JOIN 改写
Join 改写指的是查询和物化使用的表相同，可以在物化视图和查询 Join 的输入或者 Join 的外层写 where，优化器对此 pattern
的查询会尝试进行透明改写。
-支持多表 Join，支持 Join 的类型为 inner，left。其他类型在不断拓展中。
+支持多表 Join，支持 Join 的类型为:
+* INNER JOIN
+* LEFT OUTER JOIN
+* RIGHT OUTER JOIN
+* FULL OUTER JOIN
+* LEFT SEMI JOIN
+* RIGHT SEMI JOIN
+* LEFT ANTI JOIN
+* RIGHT ANTI JOIN
**用例1:**
diff --git
a/versioned_docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
b/versioned_docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
index 2d166fe0f3ec..84020ed436c3 100644
---
a/versioned_docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
+++
b/versioned_docs/version-2.1/query-acceleration/async-materialized-view/query-async-materialized-view.md
@@ -151,8 +151,16 @@ Join rewriting refers to when the tables used in the query
and the materializati
In this case, the optimizer will attempt transparent rewriting by either
joining the input of the materialized
view with the query or placing the join in the outer layer of the query's
WHERE clause.
-This pattern of rewriting is supported for multi-table joins and supports
inner and left join types.
-Support for other types is continually expanding.
+This pattern of rewriting is supported for multi-table joins and supported
join types is as following:
+
+* INNER JOIN
+* LEFT OUTER JOIN
+* RIGHT OUTER JOIN
+* FULL OUTER JOIN
+* LEFT SEMI JOIN
+* RIGHT SEMI JOIN
+* LEFT ANTI JOIN
+* RIGHT ANTI JOIN
**Case 1:**
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
