Peter Varga created HIVE-23671:
----------------------------------

             Summary: MSCK repair should handle transactional tables in certain 
usecases
                 Key: HIVE-23671
                 URL: https://issues.apache.org/jira/browse/HIVE-23671
             Project: Hive
          Issue Type: Improvement
          Components: Metastore
            Reporter: Peter Varga
            Assignee: Peter Varga


The MSCK REPAIR tool does not handle transactional tables too well. It can find 
and add new partitions the same way as for non-transactional tables, but since 
the writeId differences are not handled, the data can not read back from the 
new partitions.

We could handle some usecases when the writeIds in the HMS and the underlying 
data are not conflicting. If the HMS does not contains allocated writes for the 
table we can seed the table with the writeIds read from the directory 
structrure.

Real life use cases could be:
 * Copy data files from one cluster to another with different HMS, create the 
table and call MSCK REPAIR
 * If the HMS db is lost, recreate the table and call MSCK REPAIR

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to