You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Sergey Nuyanzin (Jira)" <ji...@apache.org> on 2024/08/13 20:22:00 UTC
[jira] [Updated] (FLINK-36050) Support enhanced `show views` statement
[ 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
I have investigated the syntax of engines as mentioned above.
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 many popular data process engine like presto/trino/spark
https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-views.html
I have investigated the syntax of engines as mentioned above.
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
> I have investigated the syntax of engines as mentioned above.
>
> 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)