[
https://issues.apache.org/jira/browse/PHOENIX-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349992#comment-14349992
]
James Taylor commented on PHOENIX-1665:
---------------------------------------
The UNNEST built-in is UNPIVOT for an ARRAY. My understanding was that you
wanted a more general UNPIVOT as described here:
https://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx
> Implement missing ARRAY built-in functions
> -------------------------------------------
>
> Key: PHOENIX-1665
> URL: https://issues.apache.org/jira/browse/PHOENIX-1665
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Labels: Java, gsoc2015, mentor, sql
>
> Take a look at the typical ARRAY built-in functions that are implemented in
> relational database systems
> (http://www.postgresql.org/docs/9.2/static/functions-array.html) and
> implement the same for Phoenix in Java following this guide:
> http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html
> Examples of missing functions include UNNEST, ARRAY_APPEND, ARRAY_FILL,
> ARRAY_PREPEND, etc.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
