You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/01/09 03:15:34 UTC

[jira] [Created] (DRILL-1970) Hive views must not be listed with the show tables command

Abhishek Girish created DRILL-1970:
--------------------------------------

             Summary: Hive views must not be listed with the show tables command
                 Key: DRILL-1970
                 URL: https://issues.apache.org/jira/browse/DRILL-1970
             Project: Apache Drill
          Issue Type: Improvement
          Components: Storage - Hive
            Reporter: Abhishek Girish
            Assignee: Jacques Nadeau


This is related to DRILL-1969. 

Until Drill can support querying of Hive Views, hive views metadata must not be visible upon issuing the "show tables" command. 

> use hive;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | Default schema changed to 'hive' |
+------------+------------+

Currently Observed:

> show tables ;
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
| hive.default | table1     |
| hive.default | table2     |
| hive.default | table1_view1     |
| hive.default | table2_view1     |
...
+--------------+------------+

Expected:

> show tables ;
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
| hive.default | table1     |
| hive.default | table2     |
+--------------+------------+




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)