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 72e23f1075e [doc](mtmv)replace mtmv (#872)
72e23f1075e is described below
commit 72e23f1075e89dd8976ba0c6483cbfe20accc2fd
Author: zhangdong <493738...@qq.com>
AuthorDate: Fri Jul 19 11:49:04 2024 +0800
[doc](mtmv)replace mtmv (#872)
replace mtmv
---
.../Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md | 23 ++++++++++++++++++++++
.../Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md | 23 ++++++++++++++++++++++
.../Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md | 23 ++++++++++++++++++++++
.../Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md | 23 ++++++++++++++++++++++
4 files changed, 92 insertions(+)
diff --git
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
index 11f24aed95f..f03862af382 100644
---
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
+++
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
@@ -39,6 +39,7 @@ This statement is used to modify asynchronous materialized
views.
```sql
ALTER MATERIALIZED VIEW mvName=multipartIdentifier ((RENAME newName=identifier)
| (REFRESH (refreshMethod | refreshTrigger | refreshMethod
refreshTrigger))
+ | REPLACE WITH MATERIALIZED VIEW newName=identifier propertyClause?
| (SET LEFT_PAREN fileProperties=propertyItemList RIGHT_PAREN))
```
@@ -69,6 +70,28 @@ For example, modifying the grace_period of mv1 to 3000ms
ALTER MATERIALIZED VIEW mv1 set("grace_period"="3000");
```
+##### REPLACE
+```sql
+ALTER MATERIALIZED VIEW [db.]mv1 REPLACE WITH MATERIALIZED VIEW mv2
+[PROPERTIES('swap' = 'true')];
+```
+Replacing atoms with two materialized views
+
+swap default is TRUE
+- If the swap parameter is set to TRUE, it is equivalent to renaming the
materialized view mv1 to mv2, and renaming mv2 to mv1 at the same time
+- If the swap parameter is set to FALSE, it is equivalent to renaming mv2 to
mv1 and deleting the original mv1
+
+For example, if you want to swap the names of mv1 and mv2
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2;
+```
+
+For example, if you want to rename mv2 to mv1 and delete the original mv1
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2
+PROPERTIES('swap' = 'false');
+```
+
### Keywords
ALTER, ASYNC, MATERIALIZED, VIEW
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
index 0bb39ff32a9..c1225fa45ae 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
@@ -39,6 +39,7 @@ ALTER ASYNC MATERIALIZED VIEW
```sql
ALTER MATERIALIZED VIEW mvName=multipartIdentifier ((RENAME newName=identifier)
| (REFRESH (refreshMethod | refreshTrigger | refreshMethod
refreshTrigger))
+ | REPLACE WITH MATERIALIZED VIEW newName=identifier propertyClause?
| (SET LEFT_PAREN fileProperties=propertyItemList RIGHT_PAREN))
```
@@ -69,6 +70,28 @@ ALTER MATERIALIZED VIEW mv1 rename mv2;
ALTER MATERIALIZED VIEW mv1 set("grace_period"="3000");
```
+##### REPLACE
+```sql
+ALTER MATERIALIZED VIEW [db.]mv1 REPLACE WITH MATERIALIZED VIEW mv2
+[PROPERTIES('swap' = 'true')];
+```
+两个物化视图进行原子的替换操作
+
+swap 默认为 TRUE
+- 如果 swap 参数为 TRUE，相当于把物化视图 mv1 重命名为 mv2 , 同时把 mv2 重命名为 mv1
+- 如果 swap 参数为 FALSE，相当于把 mv2 重命名为 mv1 ，原有的 mv1 被删除
+
+例如想把 mv1 和 mv2 的名字互换
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2;
+```
+
+例如想把 mv2 重命名为 mv1，并删除原先的 mv1
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2
+PROPERTIES('swap' = 'false');
+```
+
### Keywords
ALTER, ASYNC, MATERIALIZED, VIEW
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
index 0bb39ff32a9..c1225fa45ae 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
@@ -39,6 +39,7 @@ ALTER ASYNC MATERIALIZED VIEW
```sql
ALTER MATERIALIZED VIEW mvName=multipartIdentifier ((RENAME newName=identifier)
| (REFRESH (refreshMethod | refreshTrigger | refreshMethod
refreshTrigger))
+ | REPLACE WITH MATERIALIZED VIEW newName=identifier propertyClause?
| (SET LEFT_PAREN fileProperties=propertyItemList RIGHT_PAREN))
```
@@ -69,6 +70,28 @@ ALTER MATERIALIZED VIEW mv1 rename mv2;
ALTER MATERIALIZED VIEW mv1 set("grace_period"="3000");
```
+##### REPLACE
+```sql
+ALTER MATERIALIZED VIEW [db.]mv1 REPLACE WITH MATERIALIZED VIEW mv2
+[PROPERTIES('swap' = 'true')];
+```
+两个物化视图进行原子的替换操作
+
+swap 默认为 TRUE
+- 如果 swap 参数为 TRUE，相当于把物化视图 mv1 重命名为 mv2 , 同时把 mv2 重命名为 mv1
+- 如果 swap 参数为 FALSE，相当于把 mv2 重命名为 mv1 ，原有的 mv1 被删除
+
+例如想把 mv1 和 mv2 的名字互换
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2;
+```
+
+例如想把 mv2 重命名为 mv1，并删除原先的 mv1
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2
+PROPERTIES('swap' = 'false');
+```
+
### Keywords
ALTER, ASYNC, MATERIALIZED, VIEW
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
index 11f24aed95f..f03862af382 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md
@@ -39,6 +39,7 @@ This statement is used to modify asynchronous materialized
views.
```sql
ALTER MATERIALIZED VIEW mvName=multipartIdentifier ((RENAME newName=identifier)
| (REFRESH (refreshMethod | refreshTrigger | refreshMethod
refreshTrigger))
+ | REPLACE WITH MATERIALIZED VIEW newName=identifier propertyClause?
| (SET LEFT_PAREN fileProperties=propertyItemList RIGHT_PAREN))
```
@@ -69,6 +70,28 @@ For example, modifying the grace_period of mv1 to 3000ms
ALTER MATERIALIZED VIEW mv1 set("grace_period"="3000");
```
+##### REPLACE
+```sql
+ALTER MATERIALIZED VIEW [db.]mv1 REPLACE WITH MATERIALIZED VIEW mv2
+[PROPERTIES('swap' = 'true')];
+```
+Replacing atoms with two materialized views
+
+swap default is TRUE
+- If the swap parameter is set to TRUE, it is equivalent to renaming the
materialized view mv1 to mv2, and renaming mv2 to mv1 at the same time
+- If the swap parameter is set to FALSE, it is equivalent to renaming mv2 to
mv1 and deleting the original mv1
+
+For example, if you want to swap the names of mv1 and mv2
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2;
+```
+
+For example, if you want to rename mv2 to mv1 and delete the original mv1
+```sql
+ALTER MATERIALIZED VIEW db1.mv1 REPLACE WITH MATERIALIZED VIEW mv2
+PROPERTIES('swap' = 'false');
+```
+
### Keywords
ALTER, ASYNC, MATERIALIZED, VIEW
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
