Using Hadoop Iceberg catalog with Hive engine on CDP 7.2

[#1]

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

[#2]

Hi @lbourgeois 

Can you try creating table using CREATE EXTERNAL TABLE command.

Let us know if this works