[
https://issues.apache.org/jira/browse/DRILL-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14285188#comment-14285188
]
Deneche A. Hakim commented on DRILL-1970:
-----------------------------------------
The problem is "show tables" doesn't display which tables are actually Hive
Views, so the user can't know beforehand which tables can be accessed. It's
easier, and less confusing, for the user to just display the tables.
> 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
> Attachments: DRILL-1970.1.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)
