Sai Hemanth Gantasala created HIVE-29643:
--------------------------------------------

             Summary: Add Primary keys to missing tables in backend schema
                 Key: HIVE-29643
                 URL: https://issues.apache.org/jira/browse/HIVE-29643
             Project: Hive
          Issue Type: Improvement
          Components: Standalone Metastore
            Reporter: Sai Hemanth Gantasala
            Assignee: Sai Hemanth Gantasala


To support high availability of the Hive Metastore using a highly available 
database is required. There are few table for which primary keys are missing in 
the metastore. It looks like it's primarily the compaction related 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)

Reply via email to