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 "Gabor Kaszab (Jira)" <ji...@apache.org> on 2021/09/17 08:40:00 UTC
[jira] [Created] (IMPALA-10920) UNNEST function for arrays in the
select list
Gabor Kaszab created IMPALA-10920:
-------------------------------------
Summary: UNNEST function for arrays in the select list
Key: IMPALA-10920
URL: https://issues.apache.org/jira/browse/IMPALA-10920
Project: IMPALA
Issue Type: New Feature
Components: Backend, Frontend
Reporter: Gabor Kaszab
Assignee: Gabor Kaszab
There is a need for implementing an UNNEST(array) function that could be given in the select list so that we can replicate Postgres functionality that has the very same.
Considering the following table:
{code:java}
CREATE TABLE tbl (
id int,
arr1 array<int>,
arr2 array<int>)
STORED AS PARQUET;
{code}
with this data:
{code:java}
1, {1,2}, {11,22,33}
{code}
A sample query would look like this:
{code:java}
SELECT id, UNNEST(arr1), UNNEST(arr2) FROM tbl;
{code}
||id||unnest(arr1)||unnest(arr2)||
|1|1|11|
|1|2|22|
|1|null|33|
Not that the expected is to 'zip' the arrays instead of joining their values to have the same behaviour as Postgres 10+.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org