[
https://issues.apache.org/jira/browse/HIVE-17306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17925536#comment-17925536
]
Kiran Velumuri commented on HIVE-17306:
---------------------------------------
This issue requires invisible columns for some tables to have as primary keys.
This feature is enabled in MySQL 8.0.23 and later.
> Support MySQL InnoDB Cluster
> ----------------------------
>
> Key: HIVE-17306
> URL: https://issues.apache.org/jira/browse/HIVE-17306
> Project: Hive
> Issue Type: Improvement
> Components: Transactions
> Reporter: Shawn Weeks
> Assignee: Steve Yeom
> Priority: Minor
> Labels: pull-request-available
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
