[FLINK-27471] Add ARRAY_DISTINCT supported in SQL & Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.18.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Sergey Nuyanzin
• Reporter: Sergey Nuyanzin
• Created: 02/May/22 11:18
• Updated: 27/Feb/23 08:47
• Resolved: 16/Feb/23 02:09

Description

Removes duplicate values from the array.

Syntax:
array_distinct(array)

Arguments:
array: An ARRAY to be handled.

Returns:

An ARRAY. If value is NULL, the result is NULL. Keeps order of elements.
Examples:

SELECT array_distinct(ARRAY[1, 2, 3, 2, 1]);
-- [1, 2, 3]
SELECT array_distinct(ARRAY[1, NULL, 1]);
-- [1, NULL]

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

Issue Links

• links to: GitHub Pull Request #19623