Skip to main content
lbourgeois
lbourgeois
Silver ⭐️⭐️
January 17, 2024
Solved

Using Hadoop Iceberg catalog with Hive engine on CDP 7.2

Hello,

Based on this example in Iceberg doc I tried to create a table using a custom hadoop catalog.

Using Hue in CDP 7.2 I performed

 

SET iceberg.catalog.hadoop_cat.type=hadoop;
SET iceberg.catalog.hadoop_cat.warehouse=s3a://my-bucket/hadoop_cat_warehouse;
CREATE TABLE iceberg_hadoop_cat_table (id Integer,name String) STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' TBLPROPERTIES ('iceberg.catalog'='hadoop_cat');

 

But received

 

Error while compiling statement: FAILED: Execution Error, return code 40000 from org.apache.hadoop.hive.ql.ddl.DDLTask. java.lang.IllegalArgumentException: Table location not set

 

Did I miss something ? Is CDP suporting that ?

Thanks,

Laurent

ggangadharan
ggangadharanAnswer
Gold ⭐️
September 5, 2025

use the following command. 

CREATE EXTERNAL TABLE ice_t (i int, s string) STORED BY ICEBERG;

 

View in thread

3 replies

jAnshula
Gold ⭐️
jAnshula
Gold ⭐️
February 15, 2024

Hi @lbourgeois 

Can you try creating table using CREATE EXTERNAL TABLE command.

Let us know if this works

Translate
ggangadharan
Gold ⭐️
ggangadharanAnswer
Gold ⭐️
September 5, 2025

use the following command. 

CREATE EXTERNAL TABLE ice_t (i int, s string) STORED BY ICEBERG;

 

Translate
VidyaSargur
Community Manager
VidyaSargur
Community Manager
September 8, 2025

@lbourgeois, Did the response assist in resolving your query? If it did, please mark the relevant reply as the solution, as it will help others locate the answer more easily in the future. 

Translate
Regards, Vidya Sargur, Community Manager 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.
Terms & ConditionsAccessibility statement