[ https://issues.apache.org/jira/browse/DRILL-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14620798#comment-14620798 ]
Deneche A. Hakim commented on DRILL-1970: ----------------------------------------- Do we still need to hide Hive views ? We do display a proper error message: {noformat} Error Message: Hive Views are Not Supported in Current Version {noformat} Hiding Hive views can add to the user's confusion. Can someone give a good justification ? otherwise I will just mark this issue as "Won'tFix". Thx! > 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)