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

[#3 · Accepted solution]

use the following command. 

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

[#4]

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