[
https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14661119#comment-14661119
]
Maryann Xue commented on PHOENIX-953:
-------------------------------------
[~ram_krish] [~jamestaylor], guess I didn't make myself clear enough.
PHOENIX-2164 is intended for VALUES only, thought it would help for "no from
clause" case for UNNEST, but not UNNEST itself. It had been designed to meet
the requirements for implementing VALUES, but was just not sure if this
iterator would meet the requirement for "no from clause" unnest as well. And I
think it would be great this iterator class can work for both cases, maybe with
some adjustment.
> Support UNNEST for ARRAY
> ------------------------
>
> Key: PHOENIX-953
> URL: https://issues.apache.org/jira/browse/PHOENIX-953
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Assignee: Dumindu Buddhika
>
> The UNNEST built-in function converts an array into a set of rows. This is
> more than a built-in function, so should be considered an advanced project.
> For an example, see the following Postgres documentation:
> http://www.postgresql.org/docs/8.4/static/functions-array.html
> http://www.anicehumble.com/2011/07/postgresql-unnest-function-do-many.html
> http://tech.valgog.com/2010/05/merging-and-manipulating-arrays-in.html
> So the UNNEST is a way of converting an array to a flattened "table" which
> can then be filtered on, ordered, grouped, etc.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
