You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Yubin Li (Jira)" <ji...@apache.org> on 2022/01/12 12:33:00 UTC

[jira] [Created] (FLINK-25631) Support enhanced `show tables` statement

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)