[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-3309: --- Fix Version/s: (was: 0.10.0) > 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 > Attachments: HIVE-3309.patch, HIVE-3309.patch > > > 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 For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3309: - Status: Open (was: Patch Available) > 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 > > Attachments: HIVE-3309.patch, HIVE-3309.patch > > > 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
[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Status: Patch Available (was: Open) > 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 > > Attachments: HIVE-3309.patch, HIVE-3309.patch > > > 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
[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Attachment: HIVE-3309.patch > 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 > > Attachments: HIVE-3309.patch, HIVE-3309.patch > > > 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
[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinna Rao Lalam updated HIVE-3309: --- Status: Open (was: Patch Available) > 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 > > Attachments: HIVE-3309.patch > > > 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
[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rohithsharma updated HIVE-3309: --- Attachment: HIVE-3309.patch > 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 > > Attachments: HIVE-3309.patch > > > 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
[jira] [Updated] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior
[ 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