Description
Ref: https://prestodb.io/docs/current/functions/array.html
Returns an array that is the result of applying function to each element of array:
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]]
Attachments
Issue Links
- relates to
-
CALCITE-3679 Allow lambda expressions in SQL queries
-
- Resolved
-
- links to
