You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jason Altekruse (JIRA)" <ji...@apache.org> on 2015/04/27 20:40:38 UTC
[jira] [Updated] (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 ]
Jason Altekruse updated DRILL-1970:
-----------------------------------
Fix Version/s: (was: 0.9.0)
1.0.0
> 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: Jason Altekruse
> Fix For: 1.0.0
>
> 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)