[SPARK-23866] Extend ALTER TABLE DROP PARTITION syntax to use all comparators

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.3.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dong Jiang
• Created: 04/Apr/18 13:18
• Updated: 08/Apr/18 04:00
• Resolved: 08/Apr/18 04:00

Description

Please add SQL support equivalent to drop multiple partitions by operators other than =, basically equivalent of https://issues.apache.org/jira/browse/HIVE-2908

"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

• duplicates: SPARK-14922 Alter Table Drop Partition Using Predicate-based Partition Spec
• links to: [Github] Pull Request #20999 (mgaido91)