You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Roc Marshal (Jira)" <ji...@apache.org> on 2021/10/08 03:45:00 UTC
[jira] [Commented] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax
to print the query of a view
[ https://issues.apache.org/jira/browse/FLINK-10230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17425935#comment-17425935 ]
Roc Marshal commented on FLINK-10230:
-------------------------------------
Could someone help me to merge it if there are nothing inappropriate ? Thank you.
> Support 'SHOW CREATE VIEW' syntax to print the query of a view
> --------------------------------------------------------------
>
> Key: FLINK-10230
> URL: https://issues.apache.org/jira/browse/FLINK-10230
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API, Table SQL / Client
> Reporter: Timo Walther
> Assignee: Roc Marshal
> Priority: Minor
> Labels: auto-deprioritized-major, auto-unassigned, pull-request-available
> Fix For: 1.15.0
>
>
> FLINK-10163 added initial support for views in SQL Client. We should add a command that allows for printing the query of a view for debugging. MySQL offers {{SHOW CREATE VIEW}} for this. Hive generalizes this to {{SHOW CREATE TABLE}}. The latter one could be extended to also show information about the used table factories and properties.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)