You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Daniel Becker (Jira)" <ji...@apache.org> on 2023/01/18 13:07:00 UTC
[jira] [Commented] (IMPALA-11831) Error with zipping unnest if the array is also selected without unnesting
[ https://issues.apache.org/jira/browse/IMPALA-11831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17678224#comment-17678224 ]
Daniel Becker commented on IMPALA-11831:
----------------------------------------
If the source is a view, the result is like IMPALA-11828:
{code:java}
select int_array, unnest(int_array) from complextypes_arrays_only_view;
+-----------+------+
| int_array | item |
+-----------+------+
| NULL | -1 |
| NULL | 1 |
| NULL | 2 |
| NULL | 3 |
| NULL | NULL |
| NULL | 1 |
| NULL | 2 |
| NULL | NULL |
| NULL | 3 |
| NULL | NULL |
+-----------+------+
{code}
Note that {{complextypes_arrays_only_view}} is a view on complextypestbl.
> Error with zipping unnest if the array is also selected without unnesting
> -------------------------------------------------------------------------
>
> Key: IMPALA-11831
> URL: https://issues.apache.org/jira/browse/IMPALA-11831
> Project: IMPALA
> Issue Type: Bug
> Reporter: Daniel Becker
> Assignee: Daniel Becker
> Priority: Major
>
> The following query returns an error:
>
> {code:java}
> select int_array, unnest(int_array) from complextypestbl;
> ERROR: IllegalStateException: null
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org