Hey! Looking for a way to control the ids (DB_ID and TABLE_ID) of newly created databases and tables.
We have a somewhat complicated use case where we replicate the metastore (and data) from a source Hive cluster to a target cluster. However new tables can be added on both source and target. We need a way to avoid unique Id collision. One way would be to make sure all databases/tables created in the target Hive start from a higher Id. We have tried to set AUTO_INCREAMENT='10000' on a metastore MySQL db, but it doesn't work. This makes us think the Id is generated by the Metastore code itself, but we cannot find the right place in the code, or if it is possible to control the logic. Any advice would be appreciated. Cheers,