[ https://issues.apache.org/jira/browse/HIVE-26311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17553572#comment-17553572 ]
Peter Vary commented on HIVE-26311: ----------------------------------- [~gaborkaszab]: Would HIVE-26250 help? > Incorrect content of array when IN operator is in the filter > ------------------------------------------------------------ > > Key: HIVE-26311 > URL: https://issues.apache.org/jira/browse/HIVE-26311 > Project: Hive > Issue Type: Bug > Reporter: Gabor Kaszab > Priority: Major > Labels: correctness > Attachments: arrays.parq > > > select id, arr1, arr2 from functional_parquet.complextypes_arrays where id % > 2 = 1 and id = 5 > {code:java} > +-----+---------------+---------------------------------------+ > | id | arr1 | arr2 | > +-----+---------------+---------------------------------------+ > | 5 | [10,null,12] | ["ten","eleven","twelve","thirteen"] | > +-----+---------------+---------------------------------------+{code} > select id, arr1, arr2 from functional_parquet.complextypes_arrays where id % > 2 = 1 *and id in (select id from functional_parquet.alltypestiny)* and id = 5; > {code:java} > +-----+-------------+---------------------------------------+ > | id | arr1 | arr2 | > +-----+-------------+---------------------------------------+ > | 5 | [10,10,12] | ["ten","eleven","twelve","thirteen"] | > +-----+-------------+---------------------------------------+ {code} > Note, the first (and correct) example returns 10, null and 12 as the items of > an array while the second query for some reaon shows 10 instead of the null > value. The only difference between the 2 examples is that in the second I > added an extra filter (that in fact doesn't filter out anything as > functional_parquet.alltypestiny's ID contains numbers from zero to ten) > -- This message was sent by Atlassian Jira (v8.20.7#820007)