[
https://issues.apache.org/jira/browse/FLINK-10230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17412003#comment-17412003
]
Roc Marshal commented on FLINK-10230:
-------------------------------------
Hi, [~twalthr], [~jark], [~yanghua], I investigated the syntax in other
systems.
MySQL
syntax:
SHOW CREATE VIEW _view_name_
[https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html]
----------
Prestodb
syntax:
---------
snowflake
syntax: don't surpported yet.
[https://docs.snowflake.com/en/sql-reference/sql/desc-view.html]
-----
trino
syntax: SHOW CREATE VIEW view_name
[https://trino.io/docs/current/sql/show-create-view.html]
------
hive
syntax: {{SHOW CREATE TABLE ([db_name.]table_name|view_name);}}
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowCreateTable]
-------
spark
syntax: don't surpported yet.
[https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-views.html]
----
presto
syntax: SHOW CREATE VIEW view_name
[https://prestodb.io/docs/current/sql/show-create-view.html]
Please let me know what are your opinions.
Thank you for your attention.
> 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
> Priority: Minor
> Labels: auto-deprioritized-major, auto-unassigned,
> pull-request-available
> Fix For: 1.14.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)
