Versions Compared

Old Version 1

changes.mady.by.user Liquan Pei

Saved on

compared with

New Version Current

changes.mady.by.user Liquan Pei

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Creating a Hive cluster with TiDB involves the following steps:

  • Meet component requirements
  • Install a Hive cluster
    • Deploy a TiDB cluster
    • Configure Hive
    • Initialize metadata
    • Launch Metastore and test

Components required

ComponentVersion
Hive3.1.2
Hadoop2.6.0-cdh-5.16.1
TiDB4.0
Java Development Kit (JDK)1.8.0_221

...

In addition, if you're interested in our MySQL-to-TiDB migration story, check out this post.

FAQ

  1. Hive Compatibility Version？

    Hive VersionStatus
    1.xNot tested
    2.0.xTested
    2.1.xTested and verified in production
    2.3.xTested and verified in production
    3.xTested


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

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

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