[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-18 Thread Yuepeng Pan (Jira) 


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

Yuepeng Pan edited comment on FLINK-10230 at 10/18/21, 10:22 AM:
-

Could you [~jark] [~twalthr] [~pnowojski] [~chesnay] help me to merge it if 
there are nothing inappropriate ? Thank you.


was (Author: rocmarshal):
Could you [~jark] [~twalthr] [~pnowojski] [~pnowojski] 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: Yuepeng Pan
>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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-18 Thread Yuepeng Pan (Jira) 


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

Yuepeng Pan edited comment on FLINK-10230 at 10/18/21, 9:34 AM:


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


was (Author: rocmarshal):
Could you [~jark] [~twalthr] [~alpinegizmo] [~pnowojski] 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: Yuepeng Pan
>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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-15 Thread Yuepeng Pan (Jira) 


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

Yuepeng Pan edited comment on FLINK-10230 at 10/15/21, 10:24 AM:
-

Could you [~jark] [~twalthr] [~alpinegizmo] [~pnowojski] help me to merge it if 
there are nothing inappropriate ? Thank you.


was (Author: rocmarshal):
Could you [~jark] [~MartijnVisser] [~twalthr] [~alpinegizmo]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: Yuepeng Pan
>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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-13 Thread Yuepeng Pan (Jira) 


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

Yuepeng Pan edited comment on FLINK-10230 at 10/14/21, 2:03 AM:


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


was (Author: rocmarshal):
Could you [~jark] [~MartijnVisser] [~twalthr] 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: Yuepeng Pan
>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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-11 Thread Roc Marshal (Jira) 


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

Roc Marshal edited comment on FLINK-10230 at 10/12/21, 3:21 AM:


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


was (Author: rocmarshal):
Could you [~jark] [~MartijnVisser]  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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-09 Thread Roc Marshal (Jira) 


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

Roc Marshal edited comment on FLINK-10230 at 10/9/21, 11:16 AM:


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


was (Author: rocmarshal):
Could you [~MartijnVisser]  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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-10-09 Thread Roc Marshal (Jira) 


[ 
https://issues.apache.org/jira/browse/FLINK-10230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)

[jira] [Comment Edited] (FLINK-10230) Support 'SHOW CREATE VIEW' syntax to print the query of a view

2021-09-08 Thread Roc Marshal (Jira) 


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

Roc Marshal edited comment on FLINK-10230 at 9/8/21, 3:20 PM:
--

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]

-

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.


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