snuyanzin commented on code in PR #27236: URL: https://github.com/apache/flink/pull/27236#discussion_r2523227720
########## docs/content/docs/dev/table/sql/show.md: ########## @@ -986,6 +988,29 @@ SHOW CREATE VIEW [catalog_name.][db_name.]view_name Show create view statement for specified view. +## SHOW MATERIALIZED VIEWS + +```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 view name and optional `LIKE` clause, whose name is whether 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, even 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 Review Comment: `TEMPORARY MATERIALIZED TABLE`s are not supported even on parsre level https://github.com/apache/flink/blob/851344d17d557a60701febd2c3c334b4519914cb/flink-table/flink-sql-parser/src/main/codegen/includes/parserImpls.ftl#L1875 ########## docs/content/docs/dev/table/sql/show.md: ########## @@ -986,6 +988,29 @@ SHOW CREATE VIEW [catalog_name.][db_name.]view_name Show create view statement for specified view. +## SHOW MATERIALIZED VIEWS + +```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 view name and optional `LIKE` clause, whose name is whether 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, even 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 Review Comment: `TEMPORARY MATERIALIZED TABLE`s are not supported even on parser level https://github.com/apache/flink/blob/851344d17d557a60701febd2c3c334b4519914cb/flink-table/flink-sql-parser/src/main/codegen/includes/parserImpls.ftl#L1875 -- 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]
