...
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 [ catalogEXTENDED ] 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
...