[HIVE-3419] drop partition does not work for non-equality oprator.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.1, 0.10.0
• Component/s: Metastore, Query Processor

Environment

Hive -0.9.1
postgres-9.0.7 as metastore.

• Assignee: Unassigned
• Reporter: Rohith Sharma K S
• Created: 31/Aug/12 06:42
• Updated: 01/Sep/12 00:50

Description

Drop partition query failes when below query is executed with postgres as metastore.Whereas when derby is used, drop partition query is pased.

create table ptestfilter (a string, b int) partitioned by (c string);
alter table ptestfilter1 add partition (c='1');
alter table ptestfilter1 add partition (c='2');
"alter table ptestfilter1 drop partition (c!='2');"--> failed