[HIVE-2908] Hive: Extend ALTER TABLE DROP PARTITION syntax to use all comparators

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 0.9.0
• Component/s: Query Processor
• Assignee: Sambavi Muthukrishnan
• Reporter: Sambavi Muthukrishnan
• Created: 27/Mar/12 17:53
• Updated: 10/Nov/14 08:38
• Resolved: 02/Apr/12 16:40

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 =.

Issue Links

• relates to: HIVE-2922 PartitionSpec should have a API for getting partition filter string instead of using toString()
• relates to: HIVE-8804 Hive: Extend DROP PARTITION syntax to use all comparators with date partition