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

msck repair table should drop the missing partitions from metastore

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0, 2.4.0, 3.1.0
    • Component/s: None
    • Labels:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: