Gabor Kaszab created HIVE-26311:
-----------------------------------
Summary: 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
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)
