[jira] [Updated] (HIVE-3824) bug if different serdes are used for different partitions
[ https://issues.apache.org/jira/browse/HIVE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3824: - Resolution: Fixed Fix Version/s: 0.11.0 Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committed. Thanks Ashutosh > bug if different serdes are used for different partitions > - > > Key: HIVE-3824 > URL: https://issues.apache.org/jira/browse/HIVE-3824 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Namit Jain >Assignee: Namit Jain > Fix For: 0.11.0 > > Attachments: hive.3824.1.patch, hive.3824.3.patch, hive.3824.4.patch > > > Consider the following testcase: > create table tst5 (key string, value string) partitioned by (ds string) > stored as rcfile; > insert overwrite table tst5 partition (ds='1') select * from src; > insert overwrite table tst5 partition (ds='2') select * from src; > insert overwrite table tst5 partition (ds='3') select * from src; > alter table tst5 stored as sequencefile; > insert overwrite table tst5 partition (ds='4') select * from src; > insert overwrite table tst5 partition (ds='5') select * from src; > insert overwrite table tst5 partition (ds='6') select * from src; > alter table tst5 set serde > 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; > insert overwrite table tst5 partition (ds='7') select * from src; > insert overwrite table tst5 partition (ds='8') select * from src; > insert overwrite table tst5 partition (ds='9') select * from src; > The following query works fine: > select key + key, value from tst5 where ((ds = '4') or (ds = '1')); > since both the partitions use ColumnarSerDe > But the following query fails: > select key + key, value from tst5 where ((ds = '4') or (ds = '1') or > (ds='7')); > since different serdes are used. -- 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-3824) bug if different serdes are used for different partitions
[ https://issues.apache.org/jira/browse/HIVE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3824: - Attachment: hive.3824.4.patch > bug if different serdes are used for different partitions > - > > Key: HIVE-3824 > URL: https://issues.apache.org/jira/browse/HIVE-3824 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Namit Jain >Assignee: Namit Jain > Attachments: hive.3824.1.patch, hive.3824.3.patch, hive.3824.4.patch > > > Consider the following testcase: > create table tst5 (key string, value string) partitioned by (ds string) > stored as rcfile; > insert overwrite table tst5 partition (ds='1') select * from src; > insert overwrite table tst5 partition (ds='2') select * from src; > insert overwrite table tst5 partition (ds='3') select * from src; > alter table tst5 stored as sequencefile; > insert overwrite table tst5 partition (ds='4') select * from src; > insert overwrite table tst5 partition (ds='5') select * from src; > insert overwrite table tst5 partition (ds='6') select * from src; > alter table tst5 set serde > 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; > insert overwrite table tst5 partition (ds='7') select * from src; > insert overwrite table tst5 partition (ds='8') select * from src; > insert overwrite table tst5 partition (ds='9') select * from src; > The following query works fine: > select key + key, value from tst5 where ((ds = '4') or (ds = '1')); > since both the partitions use ColumnarSerDe > But the following query fails: > select key + key, value from tst5 where ((ds = '4') or (ds = '1') or > (ds='7')); > since different serdes are used. -- 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-3824) bug if different serdes are used for different partitions
[ https://issues.apache.org/jira/browse/HIVE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3824: - Assignee: Namit Jain Status: Patch Available (was: Open) > bug if different serdes are used for different partitions > - > > Key: HIVE-3824 > URL: https://issues.apache.org/jira/browse/HIVE-3824 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Namit Jain >Assignee: Namit Jain > Attachments: hive.3824.1.patch, hive.3824.3.patch > > > Consider the following testcase: > create table tst5 (key string, value string) partitioned by (ds string) > stored as rcfile; > insert overwrite table tst5 partition (ds='1') select * from src; > insert overwrite table tst5 partition (ds='2') select * from src; > insert overwrite table tst5 partition (ds='3') select * from src; > alter table tst5 stored as sequencefile; > insert overwrite table tst5 partition (ds='4') select * from src; > insert overwrite table tst5 partition (ds='5') select * from src; > insert overwrite table tst5 partition (ds='6') select * from src; > alter table tst5 set serde > 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; > insert overwrite table tst5 partition (ds='7') select * from src; > insert overwrite table tst5 partition (ds='8') select * from src; > insert overwrite table tst5 partition (ds='9') select * from src; > The following query works fine: > select key + key, value from tst5 where ((ds = '4') or (ds = '1')); > since both the partitions use ColumnarSerDe > But the following query fails: > select key + key, value from tst5 where ((ds = '4') or (ds = '1') or > (ds='7')); > since different serdes are used. -- 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-3824) bug if different serdes are used for different partitions
[ https://issues.apache.org/jira/browse/HIVE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3824: - Attachment: hive.3824.3.patch > bug if different serdes are used for different partitions > - > > Key: HIVE-3824 > URL: https://issues.apache.org/jira/browse/HIVE-3824 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Namit Jain > Attachments: hive.3824.1.patch, hive.3824.3.patch > > > Consider the following testcase: > create table tst5 (key string, value string) partitioned by (ds string) > stored as rcfile; > insert overwrite table tst5 partition (ds='1') select * from src; > insert overwrite table tst5 partition (ds='2') select * from src; > insert overwrite table tst5 partition (ds='3') select * from src; > alter table tst5 stored as sequencefile; > insert overwrite table tst5 partition (ds='4') select * from src; > insert overwrite table tst5 partition (ds='5') select * from src; > insert overwrite table tst5 partition (ds='6') select * from src; > alter table tst5 set serde > 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; > insert overwrite table tst5 partition (ds='7') select * from src; > insert overwrite table tst5 partition (ds='8') select * from src; > insert overwrite table tst5 partition (ds='9') select * from src; > The following query works fine: > select key + key, value from tst5 where ((ds = '4') or (ds = '1')); > since both the partitions use ColumnarSerDe > But the following query fails: > select key + key, value from tst5 where ((ds = '4') or (ds = '1') or > (ds='7')); > since different serdes are used. -- 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-3824) bug if different serdes are used for different partitions
[ https://issues.apache.org/jira/browse/HIVE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3824: - Attachment: hive.3824.1.patch > bug if different serdes are used for different partitions > - > > Key: HIVE-3824 > URL: https://issues.apache.org/jira/browse/HIVE-3824 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Namit Jain > Attachments: hive.3824.1.patch > > > Consider the following testcase: > create table tst5 (key string, value string) partitioned by (ds string) > stored as rcfile; > insert overwrite table tst5 partition (ds='1') select * from src; > insert overwrite table tst5 partition (ds='2') select * from src; > insert overwrite table tst5 partition (ds='3') select * from src; > alter table tst5 stored as sequencefile; > insert overwrite table tst5 partition (ds='4') select * from src; > insert overwrite table tst5 partition (ds='5') select * from src; > insert overwrite table tst5 partition (ds='6') select * from src; > alter table tst5 set serde > 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'; > insert overwrite table tst5 partition (ds='7') select * from src; > insert overwrite table tst5 partition (ds='8') select * from src; > insert overwrite table tst5 partition (ds='9') select * from src; > The following query works fine: > select key + key, value from tst5 where ((ds = '4') or (ds = '1')); > since both the partitions use ColumnarSerDe > But the following query fails: > select key + key, value from tst5 where ((ds = '4') or (ds = '1') or > (ds='7')); > since different serdes are used. -- 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
