Daniel Becker created IMPALA-11828:
--------------------------------------
Summary: Incorrect result of joining unnest with view
Key: IMPALA-11828
URL: https://issues.apache.org/jira/browse/IMPALA-11828
Project: IMPALA
Issue Type: Bug
Reporter: Daniel Becker
Assignee: Daniel Becker
If an array-typed column comes from a view or an inline view and is
unnest-joined with itself, the (non-unnested) array column in the result will
contain NULLs instead of the arrays.
The following queries both produce incorrect results. Note that
{{complextypes_arrays_only_view}} is a view on {{complextypestbl}} so these
queries are functionally equivalent:
{code:java}
use functional_parquet;
with sub as (select int_array from complextypestbl) select int_array, a.item
from sub, sub.int_array a;{code}
{code:java}
use functional_parquet;
select int_array, a.item from complextypes_arrays_only_view,
complextypes_arrays_only_view.int_array a;{code}
{code:java}
+-----------+------+
| int_array | item |
+-----------+------+
| NULL | -1 |
| NULL | 1 |
| NULL | 2 |
| NULL | 3 |
| NULL | NULL |
| NULL | 1 |
| NULL | 2 |
| NULL | NULL |
| NULL | 3 |
| NULL | NULL |
+-----------+------+{code}
If no views are involved and the table is queried directly, the result is
correct:
{code:java}
use functional_parquet;
select int_array, a.item from complextypestbl, complextypestbl.int_array
a;{code}
{code:java}
+------------------------+------+
| int_array | item |
+------------------------+------+
| [-1] | -1 |
| [1,2,3] | 1 |
| [1,2,3] | 2 |
| [1,2,3] | 3 |
| [null,1,2,null,3,null] | NULL |
| [null,1,2,null,3,null] | 1 |
| [null,1,2,null,3,null] | 2 |
| [null,1,2,null,3,null] | NULL |
| [null,1,2,null,3,null] | 3 |
| [null,1,2,null,3,null] | NULL |
+------------------------+------+{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]
