Load Iceberg Table on PowerBI Desktop

[#1]

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?

[#2 · Accepted solution]

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.

[#3]

@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.

[#4]

Hi @DianaTorres ,

Many thanks for the help.

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

[#5 · Accepted solution]

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.

[#6]

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?

[#7]

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.

[#8 · Accepted solution]

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

[#9]

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...