[jira] [Commented] (PHOENIX-5543) Implement show schemas / show tables SQL commands

["Bharath Vissapragada (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16958433#comment-16958433 ] 

Bharath Vissapragada commented on PHOENIX-5543:
-----------------------------------------------

I have a patch for this and I'll submit a pull request shortly. Also, can someone please assign this to me and add me as a contributor to the project?

> Implement show schemas / show tables SQL commands
> -------------------------------------------------
>
>                 Key: PHOENIX-5543
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5543
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.15.0, 5.1.0
>            Reporter: Bharath Vissapragada
>            Priority: Minor
>
> Currently users rely on {{!tables}} and {{!schemas}} commands provided by sqlline which pulls the information using the standard JDBC metadata calls like {{getTables()}} and {{getSchemas()}}.
> Most other databases (like mysql[1,2]) implement these as first class SQL commands that gives the user more flexibility in querying by adding necessary filters and looking up for table information in specific schemas. The ask here is to implement the following SQL commands.
> {noformat}
> SHOW SCHEMAS [LIKE '<pattern>']
> SHOW TABLES [IN <schema>] [LIKE '<pattern>']
> {noformat}
> [1] https://dev.mysql.com/doc/refman/8.0/en/show-tables.html
> [2] https://dev.mysql.com/doc/refman/8.0/en/show-databases.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)