...
In addition, if you're interested in our MySQL-to-TiDB migration story, check out this post.
FAQ
Hive Compatibility Version?
Hive Version Status 1.x Not tested 2.0.x Tested 2.1.x Tested and verified in production 2.3.x Tested and verified in production 3.x Tested - Do the schemas in the Hive metastore database need to be changed?For Hive version 2.1.x and 2.3.x,no schema change is needed.
Does the foreign key constraint for tables in Hive the metastore database affecting migrating to TiDB? For the versions tested, foreign key constraints do not impact using TiDB as Hive metastore.
How to handle `MetaException(message:The isolation level 'SERIALIZABLE' is not supported. Set tidb_skip_isolation_level_check=1 to skip this error) ` exception? In TiDB, execute the following command `set global tidb_skip_isolation_level_check=1;` to skip check.