Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-23671

MSCK repair should handle transactional tables in certain usecases

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Metastore

      Description

      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

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pvargacl Peter Varga
                Reporter:
                pvargacl Peter Varga
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 11h 50m
                  11h 50m