[FLINK-31118] Add ARRAY_UNION supported in SQL & Table API

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• 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: 17/Feb/23 09:40
• Updated: 16/May/23 09:32
• Resolved: 16/May/23 09:32

Description

Remove all elements that equal to element from array.

Syntax:
array_union(array)

Arguments:
array: An ARRAY to be handled.

Returns:

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

> SELECT array_union(array(1, 2, 3), array(1, 3, 5));
 [1,2,3,5] 

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

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

Issue Links

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