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/15 14:38:00 UTC
[jira] [Comment Edited] (FLINK-31380) Add filter support for ShowCatalog and ShowDatabaseOperation
[ 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/15/23 2:37 PM:
----------------------------------------------------------
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
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
show tables;
+------------+
| table name |
+------------+
| items |
| orders |
+------------+
2 rows in set
show tables from db1 like '%n';
-- show tables from catalog1.db1 like '%n';
-- show tables from catalog1.db1 ilike '%n';
-- show tables in db1 like '%n';
-- show tables in db1 ilike '%n';
-- show tables in catalog1.db1 like '%n';
-- show tables in catalog1.db1 ilike '%n';
+------------+
| table name |
+------------+
| person |
+------------+
1 row in set
show tables from db1 not like '%n';
-- show tables from catalog1.db1 not like '%n';
-- show tables from catalog1.db1 not ilike '%n';
-- show tables in db1 not like '%n';
-- show tables in db1 not ilike '%n';
-- show tables in catalog1.db1 not like '%n';
-- show tables in catalog1.db1 not ilike '%n';
+------------+
| table name |
+------------+
| dim |
+------------+
1 row in set
how columns from orders like '%r';
-- show columns from database1.orders like '%r';
-- show columns from database1.orders ilike '%r';
-- show columns from catalog1.database1.orders like '%r';
-- show columns from catalog1.database1.orders ilike '%r';
-- show columns in orders like '%r';
-- show columns in orders ilike '%r';
-- show columns in database1.orders like '%r';
-- show columns in database1.orders ilike '%r';
-- show columns in catalog1.database1.orders like '%r';
-- show columns in catalog1.database1.orders ilike '%r';
+------+--------+-------+-----------+--------+-----------+
| name | type | null | key | extras | watermark |
+------+--------+-------+-----------+--------+-----------+
| user | BIGINT | false | PRI(user) | | |
+------+--------+-------+-----------+--------+-----------+
1 row in set
show views;
+-----------+
| view name |
+-----------+
| orders |
| persons |
+-----------+
2 rows in set
show views from db1;
-- show views from catalog1.db1;
-- show views in db1;
-- show views in catalog1.db1;
+-----------+
| view name |
+-----------+
| persons |
| orders |
+-----------+
2 rows in set
show views from db1 like 'p%';
-- show views from catalog1.db1 like 'p%';
-- show views from catalog1.db1 ilike 'p%';
-- show views in db1 like 'p%';
-- show views in db1 ilike 'p%';
-- show views in catalog1.db1 like 'p%';
-- show views in catalog1.db1 ilike 'p%';
+-----------+
| view name |
+-----------+
| persons |
+-----------+
1 row in set
show views from db1 not like 'p%';
-- show views from catalog1.db1 not like 'p%';
-- show views from catalog1.db1 not ilike 'p%';
-- show views in db1 not like 'p%';
-- show views in db1 not ilike 'p%';
-- show views in catalog1.db1 not like 'p%';
-- show views in catalog1.db1 not ilike 'p%';
+-----------+
| view name |
+-----------+
| orders |
+-----------+
1 row in set
show functions;
+-------------------------------+
| function name |
+-------------------------------+
| AGG_DECIMAL_MINUS |
| AGG_DECIMAL_PLUS |
| ARRAY_CONTAINS |
| ARRAY_DISTINCT |
| COALESCE |
... omit some middle functions |
| withColumns |
| withoutColumns |
+-------------------------------+
186 rows in set
show functions from db1;
-- show functions from catalog1.db1;
-- show functions in db1;
-- show functions in catalog1.db1;
+-------------------------------+
| function name |
+-------------------------------+
| AGG_DECIMAL_MINUS |
| AGG_DECIMAL_PLUS |
| ARRAY_CONTAINS |
| ARRAY_DISTINCT |
| COALESCE |
... omit some middle functions |
| withColumns |
| withoutColumns |
+-------------------------------+
186 rows in set
show functions from db1 like 'p%';
-- show functions from catalog1.db1 like 'p%';
-- show functions from catalog1.db1 ilike 'p%';
-- show functions in db1 like 'p%';
-- show functions in db1 ilike 'p%';
-- show functions in catalog1.db1 like 'p%';
-- show functions in catalog1.db1 ilike 'p%';
+---------------+
| function name |
+---------------+
| parseUrl |
| pi |
| plus |
| position |
| power |
| proctime |
+---------------+
6 rows in set
show modules;
+-------------+
| module name |
+-------------+
| core |
+-------------+
1 row in set
show modules like '%e';
-- show modules ilike '%e';
+-------------+
| module name |
+-------------+
| core |
+-------------+
show modules not like '%a';
-- show modules not ilike '%a';
-- show modules not ilike '%A';
+-------------+
| module name |
+-------------+
| core |
+-------------+
show jars;
+------------+
| jars |
+------------+
| /tmp/a.jar |
| /tmp/b.jar |
+------------+
2 rows in set
show jars like '%a.jar';
-- show jars ilike '%a.jar';
-- show jars ilike '%A.jar';
+------------+
| jars |
+------------+
| /tmp/a.jar |
+------------+
1 row in set
show jars not like '%b.jar';
-- show jars not ilike '%a.jar';
-- show jars not ilike '%A.jar';
+------------+
| jars |
+------------+
| /tmp/a.jar |
+------------+
1 row in set
show jobs;
+----------------------------------+-------------------------------------------------+----------+-------------------------+
| job id | job name | status | start time |
+----------------------------------+-------------------------------------------------+----------+-------------------------+
| 6e82aeaf0b30ef1611e1486b49fcf5e9 | collect | FINISHED | 2023-03-01T15:00:47.038 |
| a72a4ab478557bf6b19eeb599852fdd1 | insert-into_default_catalog.default_database.t2 | FINISHED | 2023-03-01T15:01:35.250 |
+----------------------------------+-------------------------------------------------+----------+-------------------------+
3 rows in set
show jobs like '%collect%';
-- show jobs ilike '%collect%';
-- show jobs ilike '%COLLECT%';
+----------------------------------+-------------------------------------------------+----------+-------------------------+
| job id | job name | status | start time |
+----------------------------------+-------------------------------------------------+----------+-------------------------+
| 6e82aeaf0b30ef1611e1486b49fcf5e9 | collect | FINISHED | 2023-03-01T15:00:47.038 |
+----------------------------------+-------------------------------------------------+----------+-------------------------+
1 row in set
show jobs not like '%collect%';
-- show jobs not ilike '%collect%';
-- show jobs not ilike '%COLLECT%';
+----------------------------------+-------------------------------------------------+----------+-------------------------+
| job id | job name | status | start time |
+----------------------------------+-------------------------------------------------+----------+-------------------------+
| a72a4ab478557bf6b19eeb599852fdd1 | insert-into_default_catalog.default_database.t2 | FINISHED | 2023-03-14T15:32:35.250 |
+----------------------------------+-------------------------------------------------+----------+-------------------------+
1 row in set
> Add filter support for ShowCatalog and ShowDatabaseOperation
> ------------------------------------------------------------
>
> 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 theme supports ShowCatalogs and ShowDatabases
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)