[FLINK-31102] Add ARRAY_REMOVE supported in SQL & Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jacky Lau
• Reporter: Jacky Lau
• Created: 16/Feb/23 09:44
• Updated: 30/Mar/23 05:05
• Resolved: 26/Mar/23 21:36

Description

Remove all elements that equal to element from array.

Syntax:
array_remove(array, needle)

Arguments:
array: An ARRAY to be handled.

Returns:

An ARRAY. If array is NULL, the result is NULL. 
Examples:

SELECT array_remove(array[1, 2, 3, null, 3], 3); 
-- [1,2,null]

See also
spark https://spark.apache.org/docs/latest/api/sql/index.html#array_remove

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

postgresql https://www.postgresql.org/docs/12/functions-array.html#ARRAY-FUNCTIONS-TABLE

Issue Links

• is a child of: FLINK-22484 Built-in functions for collections
• links to: GitHub Pull Request #22144