Google Git
Sign in
apache / phoenix / 116b9bd667b0cf0e22a45c42e878e97c20c1fc58
commit116b9bd667b0cf0e22a45c42e878e97c20c1fc58[log] [tgz]
authorBharath Vissapragada <bharathv@apache.org>Tue Oct 22 14:14:10 2019 -0700
committerGeoffrey Jacoby <gjacoby@apache.org>Thu May 07 15:29:14 2020 -0700
treee29ad62b9252295a9a42cebc22b38853f3475045
parent364b62c34547a3a4e4b5496e1e50eee1d6daa514 [diff]
PHOENIX-5543: Implement SHOW TABLES/SCHEMAS sql commands

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.
12 files changed
tree: e29ad62b9252295a9a42cebc22b38853f3475045
  1. bin/
  2. config/
  3. dev/
  4. docs/
  5. examples/
  6. phoenix-assembly/
  7. phoenix-client/
  8. phoenix-core/
  9. phoenix-hbase-compat-2.0.1/
  10. phoenix-hbase-compat-2.1.6/
  11. phoenix-hbase-compat-2.2.1/
  12. phoenix-pherf/
  13. phoenix-protocol/
  14. phoenix-server/
  15. phoenix-tracing-webapp/
  16. src/
  17. .gitignore
  18. BUILDING.md
  19. KEYS
  20. LICENSE
  21. NOTICE
  22. pom.xml
  23. README.md
README.md

logo

Apache Phoenix is a SQL skin over HBase delivered as a client-embedded JDBC driver targeting low latency queries over HBase data. Visit the Apache Phoenix website here.

Copyright ©2014 Apache Software Foundation. All Rights Reserved.