Migrate Hive table to Iceberg feature

CDP supports Hive table migration from Hive to Iceberg tables using ALTER TABLE to set the table properties.

In-place table migration process

In-place table migration saves time generating Iceberg tables. There is no need to regenerate data files. Only metadata, which points to source data files, is regenerated.

To convert a Hive table to an Iceberg V1 table, use the following syntax:

ALTER TABLE table_name CONVERT TO ICEBERG;

To convert a Hive table to an Iceberg V2 table, you must run two queries. Use the following syntax:

ALTER TABLE table_name CONVERT TO ICEBERG
    
ALTER TABLE table_name SET TBLPROPERTIES ('format-version' = '2'
    ...)

In-place table migration saves time generating Iceberg tables. There is no need to regenerate data files. Only metadata, which points to source data files, is regenerated.