[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 array) 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: 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 array) 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 array) 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 array) 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 array) 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 array) 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 array) 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=30555&id=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 array) 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 array) 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
