[
https://issues.apache.org/jira/browse/HIVE-26311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabor Kaszab updated HIVE-26311:
--------------------------------
Attachment: arrays.parq
> 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)
