Bharath Vissapragada created PHOENIX-5543:
---------------------------------------------
Summary: 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
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)
