SHOW CREATE TABLE in Flink SQL

[Gyula Fóra]

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

[Jeff Zhang]

+1 for this, maybe we can add 'describe extended table' like hive

Gyula Fóra <[hidden email]> 于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

--

[Jark Wu-3]

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 <[hidden email]> wrote:

+1 for this, maybe we can add 'describe extended table' like hive

Gyula Fóra <[hidden email]> 于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

[Gyula Fóra]

Thanks for the positive feedback and creating the JIRA ticket :)

Gyula

On Mon, Mar 2, 2020 at 3:15 PM Jark Wu <[hidden email]> 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 <[hidden email]> wrote:

+1 for this, maybe we can add 'describe extended table' like hive

Gyula Fóra <[hidden email]> 于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

[JingsongLee]

Hi,

Some previous discussion in [1], FYI

[1] https://issues.apache.org/jira/browse/FLINK-10230

Best,

Jingsong Lee

------------------------------------------------------------------

From:Jark Wu <[hidden email]>

Send Time:2020年3月2日(星期一) 22:42

To:Jeff Zhang <[hidden email]>

Cc:"Gyula Fóra" <[hidden email]>; user <[hidden email]>

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 <[hidden email]> wrote:

+1 for this, maybe we can add 'describe extended table' like hive

Gyula Fóra <[hidden email]> 于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