drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1970) Hive views must not be listed with the show tables command
Date Fri, 09 Jan 2015 02:15:34 GMT
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)

Mime
View raw message