- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Load Iceberg Table on PowerBI Desktop
- Labels:
-
Apache Iceberg
Created 07-08-2024 07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created 07-09-2024 04:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 07-09-2024 06:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 07-08-2024 10:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Regards,
Diana Torres,Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:
Created 07-09-2024 01:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @DianaTorres ,
Many thanks for the help.
I'll wait the feedback of @RangaReddy about the encountered issue explained above.
Created 07-09-2024 04:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 07-09-2024 05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created 07-09-2024 06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 07-09-2024 06:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 09-10-2024 05:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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