[ https://issues.apache.org/jira/browse/HIVE-3419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13445818#comment-13445818 ]
rohithsharma commented on HIVE-3419: ------------------------------------ I think it looks like problem with datanuclues.I found another issue HIVE-2609 with same cause for the problem. > drop partition does not work for non-equality oprator. > ------------------------------------------------------ > > Key: HIVE-3419 > URL: https://issues.apache.org/jira/browse/HIVE-3419 > Project: Hive > Issue Type: Bug > Components: Metastore, Query Processor > Affects Versions: 0.10.0, 0.9.1 > Environment: Hive -0.9.1 > postgres-9.0.7 as metastore. > Reporter: rohithsharma > > 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 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira