[
https://issues.apache.org/jira/browse/HIVE-17306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17270035#comment-17270035
]
Frédéric Descamps commented on HIVE-17306:
------------------------------------------
MySQL 8.0.23 supports now invisible column that could be used as Primary Key.
This might be useful to solve this issue. See
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
> 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
>
> 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.3.4#803005)
