morrySnow commented on code in PR #872:
URL: https://github.com/apache/doris-website/pull/872#discussion_r1682306710
##########
versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md:
##########
@@ -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
Review Comment:
```suggestion
- If the swap parameter is set to FALSE, it is equivalent to renaming mv2 to
mv1 and deleting the original mv1
```
##########
docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-ASYNC-MATERIALIZED-VIEW.md:
##########
@@ -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
Review Comment:
```suggestion
- If the swap parameter is set to FALSE, it is equivalent to renaming mv2 to
mv1 and deleting the original mv1
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
