Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Currently the show tables functionality lists all the tables in all the databases/schemas. It should only list the tables in the user's current database/schema
drill> use INFORMATION_SCHEMA;
drill> show tables;
------------------------+
| TABLE_SCHEMA | TABLE_NAME |
------------------------+
| hive.default | t1 |
| hive.default | students |
| hive.default | empty_test |
| hive | t1 |
| hive | students |
| hive | empty_test |
| INFORMATION_SCHEMA | VIEWS |
| INFORMATION_SCHEMA | COLUMNS |
| INFORMATION_SCHEMA | TABLES |
| INFORMATION_SCHEMA | CATALOGS |
| INFORMATION_SCHEMA | SCHEMATA |
------------------------+