[jira] [Commented] (IMPALA-11038) Zipping unnest should work on arrays from views

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-11038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17517320#comment-17517320 ] 

ASF subversion and git services commented on IMPALA-11038:
----------------------------------------------------------

Commit 32e2ace38df03b6a760d636154c0ca78304568de in impala's branch refs/heads/master from Gabor Kaszab
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=32e2ace38 ]

IMPALA-11038: Zipping unnest from view

IMPALA-10920 introduced zipping unnest functionality for arrays that
are in a table. This patch improves that support further by accepting
inputs from views as well.

Testing:
 - Added planner tests to verify which execution node handles the
   predicates on unnested items.
 - E2E tests for both unnesting syntaxes (select list and from clause)
   to cover when the source of the unnested arrays is not a table but a
   view. Also tested multi-level views and filtering the unnested items
   on different levels.

Change-Id: I68f649dda9e41f257e7f6596193d07b24049f92a
Reviewed-on: http://gerrit.cloudera.org:8080/18094
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: Gabor Kaszab <ga...@cloudera.com>


> Zipping unnest should work on arrays from views
> -----------------------------------------------
>
>                 Key: IMPALA-11038
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11038
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Backend, Frontend
>            Reporter: Gabor Kaszab
>            Assignee: Gabor Kaszab
>            Priority: Major
>              Labels: complextype
>
> IMPALA-10920 introduced zipping unnest functionality. However, it only works for arrays in tables, but doesn't support views as a source.
> {code:java}
> SELECT unnest(arr1) FROM view_name;
> {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org