This is an automated email from the ASF dual-hosted git repository.
snuyanzin pushed a commit to branch release-2.2
in repository https://gitbox.apache.org/repos/asf/flink.git
The following commit(s) were added to refs/heads/release-2.2 by this push:
new ca9f7b75959 [hotfix][docs] Add `SHOW MATERIALIZED TABLES`, `SHOW
CREATE MATERIALIZED TABLE` to doc
ca9f7b75959 is described below
commit ca9f7b7595943dc722aaf3a407d9a58cbbf49c0d
Author: Sergey Nuyanzin <[email protected]>
AuthorDate: Fri Nov 14 21:46:50 2025 +0100
[hotfix][docs] Add `SHOW MATERIALIZED TABLES`, `SHOW CREATE MATERIALIZED
TABLE` to doc
---
docs/content.zh/docs/dev/table/sql/show.md | 25 +++++++++++++++++++++++++
docs/content/docs/dev/table/sql/show.md | 29 +++++++++++++++++++++++++++--
2 files changed, 52 insertions(+), 2 deletions(-)
diff --git a/docs/content.zh/docs/dev/table/sql/show.md
b/docs/content.zh/docs/dev/table/sql/show.md
index 5b478a89d55..d8f631eb451 100644
--- a/docs/content.zh/docs/dev/table/sql/show.md
+++ b/docs/content.zh/docs/dev/table/sql/show.md
@@ -39,6 +39,8 @@ SHOW CREATE 语句用于打印给定对象的创建 DDL 语句。当前的 SHOW
- SHOW CURRENT DATABASE
- SHOW TABLES
- SHOW CREATE TABLE
+- SHOW MATERIALIZED TABLES
+- SHOW CREATE MATERIALIZED TABLE
- SHOW COLUMNS
- SHOW PARTITIONS
- SHOW PROCEDURES
@@ -975,6 +977,29 @@ The syntax of sql pattern in `LIKE` clause is the same as
that of `MySQL` dialec
SHOW CREATE VIEW [catalog_name.][db_name.]view_name
```
+## SHOW MATERIALIZED TABLES
+
+```sql
+SHOW MATERIALIZED TABLES [ ( FROM | IN ) [catalog_name.]database_name ] [
[NOT] LIKE <sql_like_pattern> ]
+```
+
+Show all materialized tables for an optionally specified database. If no
database is specified then the materialized tables are returned from the
current database. Additionally, the output of this statement may be filtered by
an optional matching pattern.
+
+**LIKE**
+Show all materialized tables with given materialized table name and optional
`LIKE` clause, whose name is similar to the `<sql_like_pattern>`.
+
+The syntax of sql pattern in `LIKE` clause is the same as that of `MySQL`
dialect.
+* `%` matches any number of characters, including zero characters, `\%`
matches one `%` character.
+* `_` matches exactly one character, `\_` matches one `_` character.
+
+## SHOW CREATE MATERIALIZED TABLE
+
+```sql
+SHOW CREATE MATERIALIZED TABLE [catalog_name.][db_name.]materialized_table_name
+```
+
+Show create materialized table statement for specified materialized table.
+
展示创建指定视图的 create 语句。
## SHOW FUNCTIONS
diff --git a/docs/content/docs/dev/table/sql/show.md
b/docs/content/docs/dev/table/sql/show.md
index 5231dd73680..bd6454ff069 100644
--- a/docs/content/docs/dev/table/sql/show.md
+++ b/docs/content/docs/dev/table/sql/show.md
@@ -43,6 +43,8 @@ Flink SQL supports the following SHOW statements for now:
- SHOW PROCEDURES
- SHOW VIEWS
- SHOW CREATE VIEW
+- SHOW MATERIALIZED TABLES
+- SHOW CREATE MATERIALIZED TABLE
- SHOW FUNCTIONS
- SHOW MODULES
- SHOW JARS
@@ -642,8 +644,8 @@ show create catalog cat2;
SHOW DATABASES [ ( FROM | IN ) catalog_name] [ [NOT] (LIKE | ILIKE)
<sql_like_pattern> ]
```
-Show all databases within optionally specified catalog.
-If no catalog is specified, then the default catalog is used.
+Show all databases within optionally specified catalog.
+If no catalog is specified, then the default catalog is used.
Additionally, a `<sql_like_pattern>` can be used to filter the databases.
**LIKE**
@@ -986,6 +988,29 @@ SHOW CREATE VIEW [catalog_name.][db_name.]view_name
Show create view statement for specified view.
+## SHOW MATERIALIZED TABLES
+
+```sql
+SHOW MATERIALIZED TABLES [ ( FROM | IN ) [catalog_name.]database_name ] [
[NOT] LIKE <sql_like_pattern> ]
+```
+
+Show all materialized tables for an optionally specified database. If no
database is specified then the materialized tables are returned from the
current database. Additionally, the output of this statement may be filtered by
an optional matching pattern.
+
+**LIKE**
+Show all materialized tables with given materialized table name and optional
`LIKE` clause, whose name is similar to the `<sql_like_pattern>`.
+
+The syntax of sql pattern in `LIKE` clause is the same as that of `MySQL`
dialect.
+* `%` matches any number of characters, including zero characters, `\%`
matches one `%` character.
+* `_` matches exactly one character, `\_` matches one `_` character.
+
+## SHOW CREATE MATERIALIZED TABLE
+
+```sql
+SHOW CREATE MATERIALIZED TABLE [catalog_name.][db_name.]materialized_table_name
+```
+
+Show create materialized table statement for specified materialized table.
+
## SHOW FUNCTIONS
```sql
