Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22133

MS Power BI does not show Views anymore

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: API, Hive, HiveServer2, ODBC
    • Labels:
      None
    • Environment:

      HDP 3.1, Hive 3.0, CentOS 7, Windows 10, Power BI, ODBC

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              oricken Oliver Ricken
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: