Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
To support high availability of the Hive Metastore using a highly available database is required. To support the MySQL InnoDB Cluster it looks like we're just missing a couple primary keys as we were already using InnoDB tables for the metastore. It looks like it's primarily the transaction tables that don't have primary keys like TXN_COMPONENTS and COMPLETED_TXN_COMPONENTS. The primary keys can be surrogate sequences if there really is no unique identifier in these tables.