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/20 11:46:00 UTC

[jira] [Commented] (FLINK-36050) Support enhanced `show views` statement

    [ https://issues.apache.org/jira/browse/FLINK-36050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875159#comment-17875159 ] 

Sergey Nuyanzin commented on FLINK-36050:
-----------------------------------------

Merged as [04b385b3a080ef8888cfdcb3071e01131223bf4f|https://github.com/apache/flink/commit/04b385b3a080ef8888cfdcb3071e01131223bf4f]

> Support enhanced `show views` statement
> ---------------------------------------
>
>                 Key: FLINK-36050
>                 URL: https://issues.apache.org/jira/browse/FLINK-36050
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API
>            Reporter: Sergey Nuyanzin
>            Assignee: Sergey Nuyanzin
>            Priority: Major
>              Labels: pull-request-available
>
> 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)