[
https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475051#comment-17475051
]
Yubin Li edited comment on FLINK-25631 at 1/13/22, 2:15 AM:
------------------------------------------------------------
[~monster#12|#12] Thanks, it's very kind of you, but I have finished the syntax
a few months ago and prepare to contribute now. maybe you could find another one
was (Author: liyubin117):
[~monster#12] Thanks, it's very kind of you, but I have finished the syntax a
few months ago and prepare to contribute now.
> Support enhanced `show tables` statement
> ----------------------------------------
>
> Key: FLINK-25631
> URL: https://issues.apache.org/jira/browse/FLINK-25631
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Affects Versions: 1.14.4
> Reporter: Yubin Li
> Priority: Major
>
> Enhanced `show tables` statement like ` show tables from db1 like 't%' ` has
> been supported broadly in many popular data process engine like
> presto/trino/spark
> [https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-tables.html]
> I have investigated the syntax of engines as mentioned above.
>
> We could use such statement to easily show the tables of specified databases
> without switching db frequently, alse we could use regexp pattern to find
> focused tables quickly from plenty of tables. besides, the new statement is
> compatible completely with the old one, users could use `show tables` as
> before.
> h3. SHOW TABLES [ ( FROM | IN ) [catalog.]db ] [ [NOT] LIKE regex_pattern ]
>
> I have implemented the syntax, demo as below:
> {code:java}
> Flink SQL> create database d1;
> [INFO] Execute statement succeed.
> Flink SQL> create table d1.b1(id int) with ('connector'='print');
> [INFO] Execute statement succeed.
> Flink SQL> create table t1(id int) with ('connector'='print');
> [INFO] Execute statement succeed.
> Flink SQL> create table m1(id int) with ('connector'='print');
> [INFO] Execute statement succeed.
> Flink SQL> show tables like 'm%';
> +------------+
> | table name |
> +------------+
> | m1 |
> +------------+
> 1 row in set
> Flink SQL> show tables from d1 like 'b%';
> +------------+
> | table name |
> +------------+
> | b1 |
> +------------+
> 1 row in set{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
