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

Hive: Extend ALTER TABLE DROP PARTITION syntax to use all comparators

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.9.0
    • Fix Version/s: 0.9.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      To drop a partition from a Hive table, this works:

      ALTER TABLE foo DROP PARTITION(ds = 'date')

      ...but it should also work to drop all partitions prior to date.

      ALTER TABLE foo DROP PARTITION(ds < 'date')

      This task is to implement ALTER TABLE DROP PARTITION for all of the comparators, < > <= >= <> = != instead of just for =.

        Attachments

        1. HIVE-2908.final.patch.txt
          34 kB
          Sambavi Muthukrishnan
        2. ASF.LICENSE.NOT.GRANTED--HIVE-2908.D2523.2.patch
          27 kB
          Phabricator
        3. ASF.LICENSE.NOT.GRANTED--HIVE-2908.D2523.1.patch
          27 kB
          Phabricator

          Issue Links

            Activity

              People

              • Assignee:
                sambavi Sambavi Muthukrishnan
                Reporter:
                sambavi Sambavi Muthukrishnan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 96h
                  96h
                  Remaining:
                  Remaining Estimate - 96h
                  96h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified