You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chris Westin (JIRA)" <ji...@apache.org> on 2015/09/30 23:29:04 UTC
[jira] [Resolved] (DRILL-1970) Hive views must not be listed with
the show tables command
[ https://issues.apache.org/jira/browse/DRILL-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Westin resolved DRILL-1970.
---------------------------------
Resolution: Fixed
Accidentally re-opened by unexpected shortcut key in JIRA....
> 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: Bug
> Components: Storage - Hive
> Reporter: Abhishek Girish
> Assignee: Chris Westin
> Fix For: Future
>
> Attachments: DRILL-1970.1.patch.txt, DRILL-1970.2.patch.txt
>
>
> 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)