[jira] [Commented] (DRILL-1970) Hive views must not be listed with the show tables command

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14284619#comment-14284619 ] 

Deneche A. Hakim commented on DRILL-1970:
-----------------------------------------

looking to the code and logs, would it make sense to update HiveSchemaFactory.getSubSchema(String name) so that it filters out views when constructing the HiveDatabaseSchema ?

> 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
>
> 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)