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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 0.9.0
    • 0.9.0
    • Query Processor
    • 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

              sambavi Sambavi Muthukrishnan
              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