[jira] [Commented] (FLINK-25631) Support enhanced `show tables` statement
[ https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475138#comment-17475138 ] Martijn Visser commented on FLINK-25631: Thanks [~jark] and [~liyubin117]! > 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 >Assignee: 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)
[jira] [Commented] (FLINK-25631) Support enhanced `show tables` statement
[ https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475133#comment-17475133 ] Jark Wu commented on FLINK-25631: - Thanks [~liyubin117], this feature sounds good to me. You can take FLINK-22885 as an example to implement it (including the tests and docs). > 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 >Assignee: 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)
[jira] [Commented] (FLINK-25631) Support enhanced `show tables` statement
[ https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475063#comment-17475063 ] Yubin Li commented on FLINK-25631: -- [~MartijnVisser] Thanks for your attention, the syntax is indeed needed to be supported by Calcite, and given the syntax definition file in flink-sql-parser module and Calcite project, this has not been supported. > 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)
[jira] [Commented] (FLINK-25631) Support enhanced `show tables` statement
[ https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17475051#comment-17475051 ] Yubin Li commented on FLINK-25631: -- [~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)
[jira] [Commented] (FLINK-25631) Support enhanced `show tables` statement
[ https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474553#comment-17474553 ] Martijn Visser commented on FLINK-25631: I'm wondering if this needs to be supported by Calcite and if that's indeed the case, if Calcite already supports this. > 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 ] -- This message was sent by Atlassian Jira (v8.20.1#820001)
[jira] [Commented] (FLINK-25631) Support enhanced `show tables` statement
[ https://issues.apache.org/jira/browse/FLINK-25631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474529#comment-17474529 ] ZhuoYu Chen commented on FLINK-25631: - 嗨, [~liyubin117] 我对这个很感兴趣,我想为 flink 做一些工作,我可以帮忙做吗? > 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 ] -- This message was sent by Atlassian Jira (v8.20.1#820001)