Skip to main content
ren97
ren97
Silver ⭐️⭐️
July 8, 2024
Solved

Load Iceberg Table on PowerBI Desktop

Hi all,

After establishing a connection to Cloudera Virtual Warehouse from PowerBI Desktop using Hive LLAP connector, I'm not able to load Iceberg tables. I receive the following error:

DataSource.Error : ODBC : ERROR [42000] [Microsoft][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: Runtime Exception org.apache.hadoop.hive.ql.metadata.HiveException: Table XXXX is an Iceberg table format which is not currently supported.

I tried also installing the Hive ODBC driver 2.7.0. I configured the User DSN and test was successful. When I try to connect form PBI Desktop, I can establish the connection but I receive the same error if I try to load an Iceberg table:

DataSource.Error: ODBC: ERROR [42000] [Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: Runtime Exception org.apache.hadoop.hive.ql.metadata.HiveException: Table XXXX  is an Iceberg table format which is not currently supported.

How can I load iceberg table on PowerBI?

RangaReddy
RangaReddyAnswer
Gold ⭐️
July 9, 2024

Hi @ren97 

Hive LLAP mainly used for accessing the Hive tables (Managed and External) and not for Iceberg tables. 

I don't think we are supported to access the Iceberg tables using PowerBI directly. 

One thing you can try configure Impala and from Impala you create iceberg table and try to access it.

 

View in thread

7 replies

DianaTorres
Community Manager
DianaTorres
Community Manager
July 8, 2024

@ren97 Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Iceberg expert @RangaReddy  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Translate
Regards, Diana Torres, Senior Community Moderator
ren97
ren97Author
Silver ⭐️⭐️
July 9, 2024

Hi @DianaTorres ,

Many thanks for the help.

I'll wait the feedback of @RangaReddy about the encountered issue explained above.

Translate
    RangaReddy
    Gold ⭐️
    RangaReddyAnswer
    Gold ⭐️
    July 9, 2024

    Hi @ren97 

    Hive LLAP mainly used for accessing the Hive tables (Managed and External) and not for Iceberg tables. 

    I don't think we are supported to access the Iceberg tables using PowerBI directly. 

    One thing you can try configure Impala and from Impala you create iceberg table and try to access it.

     

    Translate
      ren97
      ren97Author
      Silver ⭐️⭐️
      July 9, 2024

      Hi @RangaReddy ,

      Many thanks for the feedback.

      Currently I didn't find any docs regarding the connection to Iceberg table by PBI Desktop. For this reason I asked in the forum.

      So neither the Impala ODBC driver would work for iceberg table, right?

      Translate
      RangaReddy
      Gold ⭐️
      RangaReddy
      Gold ⭐️
      July 9, 2024

      Hi @ren97 

      We don't have any setup to test your scenario. We can access iceberg table using impala, so i asked you to test. 

      We have internal tools like Hue, Zeppelin by using these you can access Iceberg table and visualise your data.

      Translate
      ren97
      ren97Author
      Silver ⭐️⭐️
      July 9, 2024

      Hi @RangaReddy ,

      I tried installing the Impala ODBC driver 2.7.0 on my local PC and I can view correctly iceberg tables from PBI Desktop.

      Many thanks for the help!

      Regards,

      Renata

      Translate
      zzeng
      Gold ⭐️⭐️
      zzeng
      Gold ⭐️⭐️
      September 11, 2024

      In CDP Public Cloud CDW Impala, you can only use HTTP+SSL to access,

      So you have to Edit the config file to specify ODBC Driver

      C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Cloudera ODBC Driver for Impala\lib\cloudera.impalaodbc.ini

      [Driver]

      AllowHostNameCNMismatch = 0
      CheckCertRevocation = 0
      TransportMode = http
      AuthMech=3

       

      https://community.cloudera.com/t5/Community-Articles/How-to-Connect-to-CDW-Impala-VW-Using-the-Power-BI-Desktop/ta-p/393013#toc-hId-1805728480

      Translate
        Terms & ConditionsAccessibility statement