[HIVE-3309] drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

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

Environment

SuSE 11 SP 1
Hadoop Cluster + Hive

• Assignee: Unassigned
• Reporter: Rohith Sharma K S
• Created: 27/Jul/12 14:18
• Updated: 19/Dec/12 06:30

Description

There is still problem in "drop partition" columns if the partition columns are mixture of string and non-string.

There is behavioural change after fixing HIVE-3063.
Before fix
==========
create table ptestfilter (a string, b int) partitioned by (c string, d int);
alter table ptestfilter add partition (c='1', d=2);
alter table ptestFilter add partition (c='2', d=1);
alter table ptestfilter drop partition (c<'2'); //this will execute fine

After fix
==========
create table ptestfilter (a string, b int) partitioned by (c string, d int);
alter table ptestfilter add partition (c='1', d=2);
alter table ptestFilter add partition (c='2', d=1);
alter table ptestfilter drop partition (c<'2'); //this will fail to execute.