question Re: Load Iceberg Table on PowerBI Desktop in Support Questions

Load Iceberg Table on PowerBI Desktop

ren97 — Mon, 08 Jul 2024 14:18:21 GMT

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?

Re: Load Iceberg Table on PowerBI Desktop

DianaTorres — Mon, 08 Jul 2024 17:21:45 GMT

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

Re: Load Iceberg Table on PowerBI Desktop

ren97 — Tue, 09 Jul 2024 08:51:04 GMT

Hi @DianaTorres ,

Many thanks for the help.

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

Re: Load Iceberg Table on PowerBI Desktop

RangaReddy — Tue, 09 Jul 2024 11:26:47 GMT

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.

Re: Load Iceberg Table on PowerBI Desktop

ren97 — Tue, 09 Jul 2024 12:56:11 GMT

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?

Re: Load Iceberg Table on PowerBI Desktop

RangaReddy — Tue, 09 Jul 2024 13:03:55 GMT

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.

Re: Load Iceberg Table on PowerBI Desktop

ren97 — Tue, 09 Jul 2024 13:43:38 GMT

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

Re: Load Iceberg Table on PowerBI Desktop

zzeng — Wed, 11 Sep 2024 00:34:23 GMT

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