[
https://issues.apache.org/jira/browse/DRILL-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14620820#comment-14620820
]
Deneche A. Hakim commented on DRILL-1970:
-----------------------------------------
Looking at one of my previous comments I see that one of the justifications to
hide Hive views was: the user has no way to know which of "show tables" results
are actually hive views, but querying "INFORMATION_SCHEMA.VIEWS" will actually
show Hive views.
> 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)
