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

Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/05/11 00:10:54 UTC

[jira] [Created] (DRILL-666) Show Tables should only list tables in the current database

Rahul Challapalli created DRILL-666:
---------------------------------------

             Summary: Show Tables should only list tables in the current database
                 Key: DRILL-666
                 URL: https://issues.apache.org/jira/browse/DRILL-666
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Rahul Challapalli


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   |
+--------------+------------+




--
This message was sent by Atlassian JIRA
(v6.2#6252)