Xiao Li created SPARK-23908:
-------------------------------
Summary: High-order function: transform(array<T>, function<T, U>)
→ array<U>
Key: SPARK-23908
URL: https://issues.apache.org/jira/browse/SPARK-23908
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 2.3.0
Reporter: Xiao Li
https://prestodb.io/docs/current/functions/array.html
Returns an array that is the result of applying function to each element of
array:
{noformat}
SELECT transform(ARRAY [], x -> x + 1); -- []
SELECT transform(ARRAY [5, 6], x -> x + 1); -- [6, 7]
SELECT transform(ARRAY [5, NULL, 6], x -> COALESCE(x, 0) + 1); -- [6, 1, 7]
SELECT transform(ARRAY ['x', 'abc', 'z'], x -> x || '0'); -- ['x0', 'abc0',
'z0']
SELECT transform(ARRAY [ARRAY [1, NULL, 2], ARRAY[3, NULL]], a -> filter(a, x
-> x IS NOT NULL)); -- [[1, 2], [3]]
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
