We are currently testing a full HDP 3.1 stack including Hive 18.104.22.168.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.