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 a98f1dfa2d3 [doc](mtmv)show create materialized view (#870)
a98f1dfa2d3 is described below
commit a98f1dfa2d3043178d3793b7b961444201172147
Author: zhangdong <493738...@qq.com>
AuthorDate: Fri Jul 19 07:47:20 2024 +0800
[doc](mtmv)show create materialized view (#870)
show create materialized view
---
.../SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md | 61 ++++++++++++++++++++++
.../SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md | 61 ++++++++++++++++++++++
.../SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md | 61 ++++++++++++++++++++++
sidebars.json | 1 +
.../SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md | 61 ++++++++++++++++++++++
versioned_sidebars/version-2.1-sidebars.json | 1 +
6 files changed, 246 insertions(+)
diff --git
a/docs/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
b/docs/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
new file mode 100644
index 00000000000..5371e85fd49
--- /dev/null
+++
b/docs/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
@@ -0,0 +1,61 @@
+---
+{
+ "title": "SHOW-CREATE-ASYNC-MATERIALIZED-VIEW",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## SHOW-CREATE-ASYNC-MATERIALIZED-VIEW
+
+### Name
+
+SHOW CREATE ASYNC MATERIALIZED VIEW
+
+### Description
+
+This statement is used to display the creation statement of asynchronous
materialized views.
+
+grammar：
+
+```sql
+SHOW CREATE MATERIALIZED VIEW [DBNAME.]MV_NAME
+```
+
+illustrate：
+
+1. `DBNAMNE` : 数据库名称
+2. `MV_NAME` : 异步物化视图的名称
+
+### Example
+
+1. View the creation statement of mv1
+
+ ```sql
+ SHOW CREATE MATERIALIZED VIEW mv1;
+ ```
+
+### Keywords
+
+ SHOW, CREATE, MATERIALIZED, VIEW, ASYNC
+
+### Best Practice
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
new file mode 100644
index 00000000000..bddfec13bae
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
@@ -0,0 +1,61 @@
+---
+{
+ "title": "SHOW-CREATE-ASYNC-MATERIALIZED-VIEW",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## SHOW-CREATE-ASYNC-MATERIALIZED-VIEW
+
+### Name
+
+SHOW CREATE ASYNC MATERIALIZED VIEW
+
+### Description
+
+该语句用于展示异步物化视图的创建语句。
+
+语法：
+
+```sql
+SHOW CREATE MATERIALIZED VIEW [DBNAME.]MV_NAME
+```
+
+说明：
+
+1. `DBNAMNE` : 数据库名称
+2. `MV_NAME` : 异步物化视图的名称
+
+### Example
+
+1. 查看 mv1 的创建语句
+
+ ```sql
+ SHOW CREATE MATERIALIZED VIEW mv1;
+ ```
+
+### Keywords
+
+ SHOW, CREATE, MATERIALIZED, VIEW, ASYNC
+
+### Best Practice
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
new file mode 100644
index 00000000000..bddfec13bae
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
@@ -0,0 +1,61 @@
+---
+{
+ "title": "SHOW-CREATE-ASYNC-MATERIALIZED-VIEW",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## SHOW-CREATE-ASYNC-MATERIALIZED-VIEW
+
+### Name
+
+SHOW CREATE ASYNC MATERIALIZED VIEW
+
+### Description
+
+该语句用于展示异步物化视图的创建语句。
+
+语法：
+
+```sql
+SHOW CREATE MATERIALIZED VIEW [DBNAME.]MV_NAME
+```
+
+说明：
+
+1. `DBNAMNE` : 数据库名称
+2. `MV_NAME` : 异步物化视图的名称
+
+### Example
+
+1. 查看 mv1 的创建语句
+
+ ```sql
+ SHOW CREATE MATERIALIZED VIEW mv1;
+ ```
+
+### Keywords
+
+ SHOW, CREATE, MATERIALIZED, VIEW, ASYNC
+
+### Best Practice
+
diff --git a/sidebars.json b/sidebars.json
index a3bb4d7eff3..275c2507431 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -1426,6 +1426,7 @@
"sql-manual/sql-statements/Show-Statements/SHOW-BROKER",
"sql-manual/sql-statements/Show-Statements/SHOW-CATALOGS",
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-TABLE",
+
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-MATERIALIZED-VIEW",
"sql-manual/sql-statements/Show-Statements/SHOW-CHARSET",
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-CATALOG",
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-DATABASE",
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
new file mode 100644
index 00000000000..5371e85fd49
--- /dev/null
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/Show-Statements/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW.md
@@ -0,0 +1,61 @@
+---
+{
+ "title": "SHOW-CREATE-ASYNC-MATERIALIZED-VIEW",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## SHOW-CREATE-ASYNC-MATERIALIZED-VIEW
+
+### Name
+
+SHOW CREATE ASYNC MATERIALIZED VIEW
+
+### Description
+
+This statement is used to display the creation statement of asynchronous
materialized views.
+
+grammar：
+
+```sql
+SHOW CREATE MATERIALIZED VIEW [DBNAME.]MV_NAME
+```
+
+illustrate：
+
+1. `DBNAMNE` : 数据库名称
+2. `MV_NAME` : 异步物化视图的名称
+
+### Example
+
+1. View the creation statement of mv1
+
+ ```sql
+ SHOW CREATE MATERIALIZED VIEW mv1;
+ ```
+
+### Keywords
+
+ SHOW, CREATE, MATERIALIZED, VIEW, ASYNC
+
+### Best Practice
+
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index 72016b03266..0bcf2970c9f 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -1399,6 +1399,7 @@
"sql-manual/sql-statements/Show-Statements/SHOW-BROKER",
"sql-manual/sql-statements/Show-Statements/SHOW-CATALOGS",
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-TABLE",
+
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-MATERIALIZED-VIEW",
"sql-manual/sql-statements/Show-Statements/SHOW-CHARSET",
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-CATALOG",
"sql-manual/sql-statements/Show-Statements/SHOW-CREATE-DATABASE",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
