Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
Request: A function, say FUNCTION_MAP, that will map a function (udf or native) across an array, returning the result. Desired syntax:
bar:
arr foo
[1,2,3] 3
[4,5,2] 2
[7,7,6] 1
SELECT FUNCTION_MAP(arr, 'LOG2') FROM bar
...should then return
[0, 0.301, 0.477] [0.602, 0.699, 0.301] [0.778, 0.778, 0.845]
...ideally, FUNCTION_MAP would take additional arguments which would be passed to the function.