[ https://issues.apache.org/jira/browse/PHOENIX-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal updated PHOENIX-5543: ----------------------------------- Fix Version/s: (was: 4.16.1) 4.16.2 > 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 > Assignee: Bharath Vissapragada > Priority: Minor > Fix For: 5.1.0, 4.17.0, 4.16.2 > > Attachments: PHOENIX-5543-4.x.v1.patch, PHOENIX-5543.master.v1.patch, > PHOENIX-5543.master.v2.patch, PHOENIX-5543.master.v3.patch > > Time Spent: 3h 40m > Remaining Estimate: 0h > > 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)