[
https://issues.apache.org/jira/browse/FLINK-31380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated FLINK-31380:
----------------------------
Description:
As FLIP discussed. We will support new syntax for these operations.
|show catalogs|SHOW CATALOGS|SHOW CATALOGS [ [NOT] (LIKE \| ILIKE)
<sql_like_pattern> ]|
|show databases|SHOW DATABASES|SHOW DATABASES [ ( FROM \| IN ) catalog_name] [
[NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
|show tables|SHOW TABLES [ ( FROM \| IN ) [catalog_name.]database_name ] [
[NOT] LIKE <sql_like_pattern> ]|SHOW TABLES [ ( FROM \| IN )
[catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
|show columns|SHOW COLUMNS ( FROM \| IN )
[[catalog_name.]database.]<table_name> [ [NOT] LIKE <sql_like_pattern>]|SHOW
COLUMNS ( FROM \| IN ) [[catalog_name.]database.]<table_name> [ [NOT] (LIKE \|
ILIKE) <sql_like_pattern>]|
|show functions|SHOW [USER] FUNCTIONS|SHOW [USER] FUNCTIONS [ ( FROM \| IN )
[catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
|show views|SHOW VIEWS|SHOW VIEWS [ ( FROM \| IN ) [catalog_name.]database_name
] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
|show modules|SHOW [FULL] MODULES|SHOW [FULL] MODULES [ [NOT] (LIKE \| ILIKE)
<sql_like_pattern> ]|
|show jars|SHOW JARS|SHOW JARS [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
|show jobs|SHOW JOBS|SHOW JOBS [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
was:
As FLIP discussed. We will support new syntax for these operations.
|show catalogs|SHOW CATALOGS|SHOW CATALOGS [ [NOT] (LIKE \| ILIKE)
<sql_like_pattern> ]| |
|show databases|SHOW DATABASES|SHOW DATABASES [ ( FROM \| IN ) catalog_name] [
[NOT] (LIKE \| ILIKE) <sql_like_pattern> ]| |
|show tables|SHOW TABLES [ ( FROM \| IN ) [catalog_name.]database_name ] [
[NOT] LIKE <sql_like_pattern> ]|SHOW TABLES [ ( FROM \| IN )
[catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]| |
|show columns|SHOW COLUMNS ( FROM \| IN )
[[catalog_name.]database.]<table_name> [ [NOT] LIKE <sql_like_pattern>]|SHOW
COLUMNS ( FROM \| IN ) [[catalog_name.]database.]<table_name> [ [NOT] (LIKE \|
ILIKE) <sql_like_pattern>]| |
|show functions|SHOW [USER] FUNCTIONS|SHOW [USER] FUNCTIONS [ ( FROM \| IN )
[catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]| |
|show views|SHOW VIEWS|SHOW VIEWS [ ( FROM \| IN ) [catalog_name.]database_name
] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]| |
|show modules|SHOW [FULL] MODULES|SHOW [FULL] MODULES [ [NOT] (LIKE \| ILIKE)
<sql_like_pattern> ]| |
|show jars|SHOW JARS|SHOW JARS [ [NOT] (LIKE \| ILIKE) <sql_like_pattern>
]|only work in [SQL
CLI|https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sqlclient/]
or [SQL
Gateway|https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql-gateway/overview/].|
|show jobs|SHOW JOBS|SHOW JOBS [ [NOT] (LIKE \| ILIKE) <sql_like_pattern>
]|only work in [SQL
CLI|https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sqlclient/]
or [SQL
Gateway|https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql-gateway/overview/].|
> Add filter support for ShowOperations
> --------------------------------------
>
> Key: FLINK-31380
> URL: https://issues.apache.org/jira/browse/FLINK-31380
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API, Table SQL / Planner
> Reporter: Ran Tao
> Priority: Major
>
> As FLIP discussed. We will support new syntax for these operations.
> |show catalogs|SHOW CATALOGS|SHOW CATALOGS [ [NOT] (LIKE \| ILIKE)
> <sql_like_pattern> ]|
> |show databases|SHOW DATABASES|SHOW DATABASES [ ( FROM \| IN ) catalog_name]
> [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
> |show tables|SHOW TABLES [ ( FROM \| IN ) [catalog_name.]database_name ] [
> [NOT] LIKE <sql_like_pattern> ]|SHOW TABLES [ ( FROM \| IN )
> [catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
> |show columns|SHOW COLUMNS ( FROM \| IN )
> [[catalog_name.]database.]<table_name> [ [NOT] LIKE <sql_like_pattern>]|SHOW
> COLUMNS ( FROM \| IN ) [[catalog_name.]database.]<table_name> [ [NOT] (LIKE
> \| ILIKE) <sql_like_pattern>]|
> |show functions|SHOW [USER] FUNCTIONS|SHOW [USER] FUNCTIONS [ ( FROM \| IN )
> [catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
> |show views|SHOW VIEWS|SHOW VIEWS [ ( FROM \| IN )
> [catalog_name.]database_name ] [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
> |show modules|SHOW [FULL] MODULES|SHOW [FULL] MODULES [ [NOT] (LIKE \| ILIKE)
> <sql_like_pattern> ]|
> |show jars|SHOW JARS|SHOW JARS [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
> |show jobs|SHOW JOBS|SHOW JOBS [ [NOT] (LIKE \| ILIKE) <sql_like_pattern> ]|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
