[jira] [Updated] (HIVE-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-4149: Assignee: Navis Status: Patch Available (was: Open) It's regression of HIVE-2540. Sorry. wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-4149: -- Attachment: HIVE-4149.D9747.1.patch navis requested code review of HIVE-4149 [jira] wrong results big outer joins with array of ints. Reviewers: JIRA HIVE-4149 Lazy array returns value of prev row instead of null when called twice Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong TEST PLAN EMPTY REVISION DETAIL https://reviews.facebook.net/D9747 AFFECTED FILES serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyArray.java serde/src/test/org/apache/hadoop/hive/serde2/lazy/TestLazyArrayMapStruct.java MANAGE HERALD RULES https://reviews.facebook.net/herald/view/differential/ WHY DID I GET THIS EMAIL? https://reviews.facebook.net/herald/transcript/23247/ To: JIRA, navis wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-4149: Priority: Critical (was: Major) wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Priority: Critical Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-4149: - Status: Open (was: Patch Available) Navis, the code changes look good. Can you add the test that I provided also ? wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Priority: Critical Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-4149: Status: Patch Available (was: Open) wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Priority: Critical Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch, HIVE-4149.D9747.2.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-4149: -- Attachment: HIVE-4149.D9747.2.patch navis updated the revision HIVE-4149 [jira] wrong results big outer joins with array of ints. Addressed comments Reviewers: JIRA REVISION DETAIL https://reviews.facebook.net/D9747 CHANGE SINCE LAST DIFF https://reviews.facebook.net/D9747?vs=30555id=30591#toc AFFECTED FILES data/files/tiny_a.txt data/files/tiny_b.txt ql/src/test/queries/clientpositive/join_array.q ql/src/test/results/clientpositive/join_array.q.out serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyArray.java serde/src/test/org/apache/hadoop/hive/serde2/lazy/TestLazyArrayMapStruct.java To: JIRA, navis wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Priority: Critical Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch, HIVE-4149.D9747.2.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-4149: - Resolution: Fixed Fix Version/s: 0.11.0 Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committed. Thanks Navis wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Navis Priority: Critical Fix For: 0.11.0 Attachments: hive.4149.1.patch, HIVE-4149.D9747.1.patch, HIVE-4149.D9747.2.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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-4149) wrong results big outer joins with array of ints
[ https://issues.apache.org/jira/browse/HIVE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-4149: - Attachment: hive.4149.1.patch wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Attachments: hive.4149.1.patch Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList arrayint) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- 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