[
https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yubin Li updated FLINK-25631:
-----------------------------
Description:
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}
was:
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 ]
> 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)
