Daniel Becker created IMPALA-12753:
--------------------------------------
Summary: Predicate missing on unnested collection from UNION
Key: IMPALA-12753
URL: https://issues.apache.org/jira/browse/IMPALA-12753
Project: IMPALA
Issue Type: Bug
Components: Backend, Frontend
Reporter: Daniel Becker
When a collection value comes from a UNNION [ALL], and is later unnested, and
there is a predicate on the unnested values, the predicate is only applied to
one side of the union.
To reproduce, create the table in Hive and add a row:
{code:java}
create table tmp (arr ARRAY<int>) stored as parquet;
insert into tmp values (array(1, 2, 3, 4, 5));{code}
Then from Impala:
{code:java}
with v as (select arr from tmp
union all select arr from tmp)
select item from v, v.arr am where item=1;
+------+
| item |
+------+
| 1 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
+------+{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
