You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Adam Kramer (JIRA)" <ji...@apache.org> on 2011/07/27 21:54:09 UTC

[jira] [Created] (HIVE-2317) Create a tool to MAP a function across an array.

Create a tool to MAP a function across an array.
------------------------------------------------

                 Key: HIVE-2317
                 URL: https://issues.apache.org/jira/browse/HIVE-2317
             Project: Hive
          Issue Type: New Feature
            Reporter: Adam Kramer


Request: A function, say FUNCTION_MAP, that will map a function (udf or native) across an array, returning the result. Desired syntax:

{code}
bar:
arr      foo
[1,2,3]  3
[4,5,2]  2
[7,7,6]  1

SELECT FUNCTION_MAP(arr, 'LOG2') FROM bar
{code}
...should then return
{code}
[0, 0.301, 0.477]
[0.602, 0.699, 0.301]
[0.778, 0.778, 0.845]
{code}

...ideally, FUNCTION_MAP would take additional arguments which would be passed to the function.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira