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

msck repair table should drop the missing partitions from metastore

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.1.0, 2.4.0, 3.0.0
    • None
    • None

    Description

      msck repair table <tablename> is often used in environments where the new partitions are loaded as directories on HDFS or S3 and users want to create the missing partitions in bulk. However, currently it only supports addition of missing partitions. If there are any partitions which are present in metastore but not on the FileSystem, it should also delete them so that it truly repairs the table metadata.

      We should be careful not to break backwards compatibility so we should either introduce a new config or keyword to add support to delete unnecessary partitions from the metastore. This way users who want the old behavior can easily turn it off.

      Attachments

        1. HIVE-17824.01-branch-2.patch
          60 kB
          Janaki Lahorani
        2. HIVE-17824.1.patch
          47 kB
          Janaki Lahorani
        3. HIVE-17824.2.patch
          47 kB
          Janaki Lahorani
        4. HIVE-17824.3.patch
          59 kB
          Janaki Lahorani
        5. HIVE-17824.4.patch
          60 kB
          Janaki Lahorani
        6. HIVE-17824-branch-2.01.patch
          60 kB
          Janaki Lahorani

        Issue Links

          Activity

            People

              janulatha Janaki Lahorani
              vihangk1 Vihang Karajgaonkar
              Votes:
              2 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: