[
https://issues.apache.org/jira/browse/FLINK-36050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Nuyanzin updated FLINK-36050:
------------------------------------
Description:
The issue is similar to table related one FLINK-25631
Enhanced {{SHOW VIEWS}} statement like {{SHOW VIEWS FROM db1 LIKE 't%'}} has
been supported broadly in popular data process engine like spark
https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-views.html
snowflake
https://docs.snowflake.com/en/sql-reference/sql/show-views
We could use such statement to easily show the views of specified databases
without switching db frequently, also we could use regexp pattern to find
focused tables quickly from plenty of tables. besides, the new statement is
compatible completely with the old one, users could use `show views` as before.
was:
The issue is similar to table related one FLINK-25631
Enhanced {{SHOW VIEWS}} statement like {{SHOW VIEWS FROM db1 LIKE 't%'}} has
been supported broadly in popular data process engine like spark
https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-views.html
We could use such statement to easily show the views of specified databases
without switching db frequently, also we could use regexp pattern to find
focused tables quickly from plenty of tables. besides, the new statement is
compatible completely with the old one, users could use `show views` as before.
> Support enhanced `show views` statement
> ---------------------------------------
>
> Key: FLINK-36050
> URL: https://issues.apache.org/jira/browse/FLINK-36050
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Reporter: Sergey Nuyanzin
> Assignee: Sergey Nuyanzin
> Priority: Major
>
> The issue is similar to table related one FLINK-25631
> Enhanced {{SHOW VIEWS}} statement like {{SHOW VIEWS FROM db1 LIKE 't%'}} has
> been supported broadly in popular data process engine like spark
> https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-views.html
> snowflake
> https://docs.snowflake.com/en/sql-reference/sql/show-views
>
> We could use such statement to easily show the views of specified databases
> without switching db frequently, also we could use regexp pattern to find
> focused tables quickly from plenty of tables. besides, the new statement is
> compatible completely with the old one, users could use `show views` as
> before.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
