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/09 06:18:00 UTC

[jira] [Comment Edited] (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 edited comment on FLINK-10230 at 10/9/21, 6:17 AM:
---------------------------------------------------------------

Could you [~MartijnVisser]  help me to merge it if there are nothing inappropriate ? Thank you.


was (Author: rocmarshal):
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)