Changing the metadata location
From Hive, you can change the table metadata location, also known as the snapshot location.
The new location must contain exactly the same metadata json file as the old location.
Before changing the metadata location, you must migrate the table to Iceberg.
After migrating a table to Iceberg, you can change the metadata location using ALTER TABLE as shown below:
ALTER TABLE t set TBLPROPERTIES ('metadata_location'='<path>/hivemetadata/00003-a1ada2b8-fc86-4b5b-8c91-400b6b46d0f2.metadata.json');