Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

show create

Support or Not

show create database

No

show create table

Yes

show create view

Yes

show create function

No


describe

Support or Not

note

describe catalog

No

has sqlNode but not support in table api

describe database

No

has sqlNode but not support in table api

describe table

Yes


describe function

No


describe view

No


current flink only supports describing tables.

...


before

after(under discussed)

Note

show catalogs

SHOW CATALOGS

SHOW CATALOGS[ [NOT] LIKE <sql_like_pattern> ]


show databases

SHOW DATABASES

SHOW DATABASES [ ( FROM | IN ) catalog_name] [ [NOT] LIKE <sql_like_pattern> ]


show functions

SHOW [USER] FUNCTIONS

SHOW [USER] FUNCTIONS [ ( FROM | IN ) [catalog_name.]database_name ] [ [NOT] LIKE <sql_like_pattern> ]


show views

SHOW VIEWS

SHOW VIEWS [ ( FROM | IN ) [catalog_name.]database_name ] [ [NOT] LIKE <sql_like_pattern> ]


show modules

SHOW [FULL] MODULES

SHOW [FULL] MODULES [ [NOT] LIKE <sql_like_pattern> ]


show jars

SHOW JARS

SHOW JARS [ [NOT] LIKE <sql_like_pattern> ]

only work in SQL CLI or SQL Gateway.

show jobs

SHOW JOBS

SHOW JOBS [ [NOT] LIKE <sql_like_pattern> ]

only work in SQL CLI or SQL Gateway.

describe catalog

Not Support

{ DESCRIBE | DESC } CATALOG catalog_name


describe database

Not Support

{ DESCRIBE | DESC } DATABASE [

catalog_name.

EXTENDED ] db_name


describe function

Not Support

{ DESCRIBE | DESC } FUNCTION [

catalog

EXTENDED ] function_name


{ DESCRIBE | DESC } [ QUERY ] input_statement

.][db_name.]function

describe query

Not Support

..




Proposed TableEnvironment SQL API Changes:

Because `TableEnvironment` is a `@publicEvolving Api`, we may add these override methods or add some SupportsXXX interface to support these features.

...


Code Block



Future Work

to be added

Compatibility, Deprecation, and Migration Plan

...