[jira] [Created] (HIVE-26311) Incorrect content of array when IN operator is in the filter

["Gabor Kaszab (Jira)" <ji...@apache.org>]

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)