question Using Hadoop Iceberg catalog with Hive engine on CDP 7.2 in Support Questions

Using Hadoop Iceberg catalog with Hive engine on CDP 7.2

lbourgeois — Wed, 17 Jan 2024 14:11:47 GMT

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

Re: Using Hadoop Iceberg catalog with Hive engine on CDP 7.2

jAnshula — Thu, 15 Feb 2024 14:44:46 GMT

Hi @lbourgeois

Can you try creating table using CREATE EXTERNAL TABLE command.

Let us know if this works

Re: Using Hadoop Iceberg catalog with Hive engine on CDP 7.2

ggangadharan — Fri, 05 Sep 2025 14:19:07 GMT

use the following command.

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

Re: Using Hadoop Iceberg catalog with Hive engine on CDP 7.2

VidyaSargur — Mon, 08 Sep 2025 06:04:45 GMT

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