You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Ran Tao (Jira)" <ji...@apache.org> on 2023/03/16 03:58:00 UTC
[jira] [Comment Edited] (FLINK-31380) Add filter support for ShowCatalog and ShowDatabases
[ https://issues.apache.org/jira/browse/FLINK-31380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700498#comment-17700498 ]
Ran Tao edited comment on FLINK-31380 at 3/16/23 3:57 AM:
----------------------------------------------------------
show catalogs;
+-----------------+
| catalog name|
+-----------------+
| catalog1|
| catalog2|
|default_catalog|
+-----------------+
3 rows in set
show catalogs like '%log1';
– show catalogs ilike '%log1';
– show catalogs ilike '%LOG1';
+--------------+
|catalog name|
+--------------+
| catalog1|
+--------------+
1 row in set
was (Author: lemonjing):
show catalogs;
+-----------------+
| catalog name|
+-----------------+
| catalog1|
| catalog2|
|default_catalog|
+-----------------+
3 rows in set
show catalogs like '%log1';
– show catalogs ilike '%log1';
– show catalogs ilike '%LOG1';
+--------------+
|catalog name|
+--------------+
| catalog1|
+--------------+
1 row in set
show databases;
+---------------+
|database name|
+---------------+
| default|
| db1|
| db2|
+---------------+
3 rows in set
show databases like 'default%';
– show databases ilike 'default%';
– show databases not like '%db1';
+---------------+
|database name|
+---------------+
| default|
+---------------+
1 row in set
show databases from catalog1;
– show databases in catalog1;
+---------------+
|database name|
+---------------+
| default|
| db1|
| db2|
+---------------+
3 rows in set
show databases from catalog1 like '%db1';
– show databases in catalog1 like '%db1';
– show databases in catalog1 ilike '%db1';
+---------------+
|database name|
+---------------+
| db1|
+---------------+
1 row in set
> Add filter support for ShowCatalog and ShowDatabases
> ----------------------------------------------------
>
> 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
> Assignee: Ran Tao
> Priority: Major
>
> As FLIP discussed. We will support new syntax for some show operations. To avoid bloat, this ticket supports ShowCatalogs and ShowDatabases.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)