[
https://issues.apache.org/jira/browse/HIVE-22133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912280#comment-16912280
]
Ivan Suller commented on HIVE-22133:
------------------------------------
In Hive 3.1 "SHOW TABLES" displays views as well (just tried it) and as far as
I'm aware of this behaviour didn't change between 3.0 and 3.1 so it should work
in 3.0 too. Maybe PowerBI doesn't use "show tables" at all.
> MS Power BI does not show Views anymore
> ---------------------------------------
>
> Key: HIVE-22133
> URL: https://issues.apache.org/jira/browse/HIVE-22133
> Project: Hive
> Issue Type: Bug
> Components: API, Hive, HiveServer2, ODBC
> Affects Versions: 3.0.0
> Environment: HDP 3.1, Hive 3.0, CentOS 7, Windows 10, Power BI, ODBC
> Reporter: Oliver Ricken
> Priority: Major
>
> Dear experts,
> We are currently testing a full HDP 3.1 stack including Hive 3.0.0.3.1.
> Before, we used a HDP 2.6 stack with Hive 1.2.1000. Our current installation
> foresees connections of Microsoft Power BI to Hive using ODBC. This worked
> fine in the HDP 2.6 (Hive 1.2) environment but yields problems in the HDP 3.1
> (Hive 3.0) context.
> Power BI does not show Hive Views to extract data from anymore but only
> tables. I suspect the newly separation of "show tables" and "show views" in
> Hive 3.0 to be behind this. While in Hive 1.2, "show tables" also showed
> views (not just tables), listing the available views of a DB now requires
> issueing "show views". My best guess is that Power BI issues "show tables" to
> harvest the list of available sources and thus misses views in Hive 3.0.
> For us it's crucial to be able to access Hive views and not just tables in
> order to migrate existing BI processes to the new cluster environment.
> Did anyone encounter this issue before and/or knows a solution or workaround?
> Any help and input is very much appreciated.
> Cheers
> Oliver
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
