[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
rohithsharma updated HIVE-3309: ------------------------------- Fix Version/s: 0.10.0 Labels: patch (was: ) Affects Version/s: 0.10.0 Status: Patch Available (was: Open) I am submitting patch with initial thoughts.Please review the patch. I will submit actual patch with test if current idea is accepted. > drop partition doesnot work for mixture of string and non-string columns for > non-equality operatior > --------------------------------------------------------------------------------------------------- > > Key: HIVE-3309 > URL: https://issues.apache.org/jira/browse/HIVE-3309 > Project: Hive > Issue Type: Bug > Components: Metastore, Query Processor > Affects Versions: 0.10.0, 0.9.1 > Environment: SuSE 11 SP 1 > Hadoop Cluster + Hive > Reporter: rohithsharma > Priority: Minor > Labels: patch > Fix For: 0.10.0 > > > 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira