Oliver Ricken created HIVE-22133:
------------------------------------
Summary: 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
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)
