Yubin Li created FLINK-25631:
--------------------------------
Summary: 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
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_name.]database_name ] [ [NOT] LIKE
regex_pattern ]
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
