You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2015/07/07 20:35:04 UTC

[jira] [Assigned] (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 ]

Deneche A. Hakim reassigned DRILL-1970:
---------------------------------------

    Assignee: Deneche A. Hakim  (was: Jason Altekruse)

> 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: Deneche A. Hakim
>             Fix For: 1.2.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)