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 87be4fbd4383 [doc](mtmv)refresh mtmv must add auto (#441)
87be4fbd4383 is described below
commit 87be4fbd43837c65c48f0aa1d3c6aeba1d9b33e5
Author: zhangdong <[email protected]>
AuthorDate: Wed Mar 20 22:40:09 2024 +0800
[doc](mtmv)refresh mtmv must add auto (#441)
---
.../sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md | 8 ++++++--
.../sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md | 8 ++++++--
.../sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md | 8 +++++---
.../sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md | 8 ++++++--
4 files changed, 23 insertions(+), 9 deletions(-)
diff --git
a/docs/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
b/docs/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
index e51424e90a85..f9c5bf29f736 100644
---
a/docs/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
+++
b/docs/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
@@ -37,19 +37,23 @@ This statement is used to manually refresh the specified
asynchronous materializ
syntax:
```sql
-REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec |
COMPLETE)?
+REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE
| AUTO)
```
Explanation:
Asynchronous refresh of data for a materialized view
+- AUTO: The calculation will determine which partitions of the materialized
view are not synchronized with the base table. (Currently, if the base table is
an external table, it is considered to be always synchronized with the
materialized view. Therefore, if the base table is an external table, it is
necessary to specify `COMPLETE` or designate the partitions to be refreshed),
and then proceed to refresh the corresponding partitions accordingly.
+- COMPLETE: It will forcibly refresh all partitions of the materialized view
without checking whether the partitions are synchronized with the base table.
+- partitionSpec: It will forcibly refresh the specified partitions without
checking whether the partitions are synchronized with the base table.
+
### Example
1. Refresh materialized view mv1 (automatically calculate the partition to be
refreshed)
```sql
- REFRESH MATERIALIZED VIEW mv1;
+ REFRESH MATERIALIZED VIEW mv1 AUTO;
```
2. Refresh partition named p_19950801_19950901和p_19950901_19951001
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
index b719d4aefe6f..7fa04faf44fb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
@@ -37,19 +37,23 @@ REFRESH MATERIALIZED VIEW
语法：
```sql
-REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec |
COMPLETE)?
+REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE
| AUTO)
```
说明：
异步刷新某个物化视图的数据
+-
AUTO：会计算物化视图的哪些分区和基表不同步（目前，如果基表是外表，会被认为始终和物化视图同步，因此如果基表是外表，需要指定`COMPLETE`或指定要刷新的分区），然后刷新对应的分区
+- COMPLETE：会强制刷新物化视图的所有分区，不会判断分区是否和基表同步
+- partitionSpec：会强制刷新指定的分区，不会判断分区是否和基表同步
+
### Example
1. 刷新物化视图mv1(自动计算要刷新的分区)
```sql
- REFRESH MATERIALIZED VIEW mv1;
+ REFRESH MATERIALIZED VIEW mv1 AUTO;
```
2. 刷新名字为p_19950801_19950901和p_19950901_19951001的分区
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
index b719d4aefe6f..bc5d90497a17 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
@@ -37,19 +37,21 @@ REFRESH MATERIALIZED VIEW
语法：
```sql
-REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec |
COMPLETE)?
+REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE
| AUTO)
```
说明：
-异步刷新某个物化视图的数据
+-
AUTO：会计算物化视图的哪些分区和基表不同步（目前，如果基表是外表，会被认为始终和物化视图同步，因此如果基表是外表，需要指定`COMPLETE`或指定要刷新的分区），然后刷新对应的分区
+- COMPLETE：会强制刷新物化视图的所有分区，不会判断分区是否和基表同步
+- partitionSpec：会强制刷新指定的分区，不会判断分区是否和基表同步
### Example
1. 刷新物化视图mv1(自动计算要刷新的分区)
```sql
- REFRESH MATERIALIZED VIEW mv1;
+ REFRESH MATERIALIZED VIEW mv1 AUTO;
```
2. 刷新名字为p_19950801_19950901和p_19950901_19951001的分区
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
b/versioned_docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
index e51424e90a85..f9c5bf29f736 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-reference/Utility-Statements/REFRESH-MATERIALIZED-VIEW.md
@@ -37,19 +37,23 @@ This statement is used to manually refresh the specified
asynchronous materializ
syntax:
```sql
-REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec |
COMPLETE)?
+REFRESH MATERIALIZED VIEW mvName=multipartIdentifier (partitionSpec | COMPLETE
| AUTO)
```
Explanation:
Asynchronous refresh of data for a materialized view
+- AUTO: The calculation will determine which partitions of the materialized
view are not synchronized with the base table. (Currently, if the base table is
an external table, it is considered to be always synchronized with the
materialized view. Therefore, if the base table is an external table, it is
necessary to specify `COMPLETE` or designate the partitions to be refreshed),
and then proceed to refresh the corresponding partitions accordingly.
+- COMPLETE: It will forcibly refresh all partitions of the materialized view
without checking whether the partitions are synchronized with the base table.
+- partitionSpec: It will forcibly refresh the specified partitions without
checking whether the partitions are synchronized with the base table.
+
### Example
1. Refresh materialized view mv1 (automatically calculate the partition to be
refreshed)
```sql
- REFRESH MATERIALIZED VIEW mv1;
+ REFRESH MATERIALIZED VIEW mv1 AUTO;
```
2. Refresh partition named p_19950801_19950901和p_19950901_19951001
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
