SHOW CREATE TABLE in Flink SQL
Hi All! I am looking for the functionality to show how a table was created or show all the properties (connector, etc.) I could only find DESCRIBE at this point which only shows the schema. Is there anything similar to "SHOW CREATE TABLE" or is this something that we should maybe add in the future? Thank you! Gyula
Re: SHOW CREATE TABLE in Flink SQL
+1 for this, maybe we can add 'describe extended table' like hive Gyula Fóra 于2020年3月2日周一 下午8:49写道: > Hi All! > > I am looking for the functionality to show how a table was created or show > all the properties (connector, etc.) > > I could only find DESCRIBE at this point which only shows the schema. > > Is there anything similar to "SHOW CREATE TABLE" or is this something that > we should maybe add in the future? > > Thank you! > Gyula > -- Best Regards Jeff Zhang
Re: SHOW CREATE TABLE in Flink SQL
big +1 for this. I created an issue for "SHOW CREATE TABLE" [1]. Many database systems also support this. We can also introduce "describe extended table" in the future but is an orthogonal requirement. Best, Jark [1]: https://issues.apache.org/jira/browse/FLINK-16384 On Mon, 2 Mar 2020 at 22:09, Jeff Zhang wrote: > +1 for this, maybe we can add 'describe extended table' like hive > > Gyula Fóra 于2020年3月2日周一 下午8:49写道: > >> Hi All! >> >> I am looking for the functionality to show how a table was created or >> show all the properties (connector, etc.) >> >> I could only find DESCRIBE at this point which only shows the schema. >> >> Is there anything similar to "SHOW CREATE TABLE" or is this something >> that we should maybe add in the future? >> >> Thank you! >> Gyula >> > > > -- > Best Regards > > Jeff Zhang >
Re: SHOW CREATE TABLE in Flink SQL
Thanks for the positive feedback and creating the JIRA ticket :) Gyula On Mon, Mar 2, 2020 at 3:15 PM Jark Wu wrote: > big +1 for this. I created an issue for "SHOW CREATE TABLE" [1]. Many > database systems also support this. > We can also introduce "describe extended table" in the future but is > an orthogonal requirement. > > Best, > Jark > > > [1]: https://issues.apache.org/jira/browse/FLINK-16384 > > On Mon, 2 Mar 2020 at 22:09, Jeff Zhang wrote: > >> +1 for this, maybe we can add 'describe extended table' like hive >> >> Gyula Fóra 于2020年3月2日周一 下午8:49写道: >> >>> Hi All! >>> >>> I am looking for the functionality to show how a table was created or >>> show all the properties (connector, etc.) >>> >>> I could only find DESCRIBE at this point which only shows the schema. >>> >>> Is there anything similar to "SHOW CREATE TABLE" or is this something >>> that we should maybe add in the future? >>> >>> Thank you! >>> Gyula >>> >> >> >> -- >> Best Regards >> >> Jeff Zhang >> >
Re: SHOW CREATE TABLE in Flink SQL
Hi, Some previous discussion in [1], FYI [1] https://issues.apache.org/jira/browse/FLINK-10230 Best, Jingsong Lee -- From:Jark Wu Send Time:2020年3月2日(星期一) 22:42 To:Jeff Zhang Cc:"Gyula Fóra" ; user Subject:Re: SHOW CREATE TABLE in Flink SQL big +1 for this. I created an issue for "SHOW CREATE TABLE" [1]. Many database systems also support this. We can also introduce "describe extended table" in the future but is an orthogonal requirement. Best, Jark [1]: https://issues.apache.org/jira/browse/FLINK-16384 On Mon, 2 Mar 2020 at 22:09, Jeff Zhang wrote: +1 for this, maybe we can add 'describe extended table' like hive Gyula Fóra 于2020年3月2日周一 下午8:49写道: Hi All! I am looking for the functionality to show how a table was created or show all the properties (connector, etc.) I could only find DESCRIBE at this point which only shows the schema. Is there anything similar to "SHOW CREATE TABLE" or is this something that we should maybe add in the future? Thank you! Gyula -- Best Regards Jeff Zhang