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

Posted to issues@phoenix.apache.org by GitBox <gi...@apache.org> on 2019/10/24 01:40:32 UTC

[GitHub] [phoenix] bharathv opened a new pull request #606: PHOENIX-5543: Implement SHOW TABLES/SCHEMAS sql commands

bharathv opened a new pull request #606: PHOENIX-5543: Implement SHOW TABLES/SCHEMAS sql commands
URL: https://github.com/apache/phoenix/pull/606
 
 
   This patch adds new SQL grammar like following
   
   - SHOW SCHEMAS [like '<pattern>']
   - SHOW TABLES [IN <schema>] [like '<pattern']
   
   Example invocations:
   
   - show schemas
   - show scemas like 'SYS%'
   - show tables
   - show tables in SYSTEM
   - show tables in SYSTEM like 'CAT%'
   
   The current way of fetching this information is by using
   !tables and !schemas via sqlline JDBC support but that is
   not flexible enough for the end users to add more fitlers.
   This approach is more inline with what other databases do.
   
   Added test coverage in parser tests and core e2e tests.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services