[SPARK-23909] High-order function: filter(array<T>, function<T, boolean>) → array<T>

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3.0
• Fix Version/s: 2.4.0
• Component/s: SQL
• Assignee: Takuya Ueshin
• Reporter: Xiao Li
• Created: 09/Apr/18 06:25
• Updated: 04/Aug/18 07:10
• Resolved: 04/Aug/18 07:10

Description

Ref: https://prestodb.io/docs/current/functions/array.html

Constructs an array from those elements of array for which function returns true:

SELECT filter(ARRAY [], x -> true); -- []
SELECT filter(ARRAY [5, -6, NULL, 7], x -> x > 0); -- [5, 7]
SELECT filter(ARRAY [5, NULL, 7, NULL], x -> x IS NOT NULL); -- [5, 7]

Issue Links

• links to: [Github] Pull Request #21965 (ueshin)
• links to: [Github] Pull Request #21982 (ueshin)