[
https://issues.apache.org/jira/browse/HIVE-22133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912442#comment-16912442
]
Rajkumar Singh commented on HIVE-22133:
---------------------------------------
can you please provide the fully qualified name of the view and view definition
if possible?
> 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)
