You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Sergey Nuyanzin (Jira)" <ji...@apache.org> on 2022/05/02 11:19:00 UTC
[jira] [Created] (FLINK-27471) Add ARRAY_DISTINCT supported in SQL & Table API
Sergey Nuyanzin created FLINK-27471:
---------------------------------------
Summary: Add ARRAY_DISTINCT supported in SQL & Table API
Key: FLINK-27471
URL: https://issues.apache.org/jira/browse/FLINK-27471
Project: Flink
Issue Type: Sub-task
Reporter: Sergey Nuyanzin
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:
{code:sql}
SELECT array_distinct(ARRAY[1, 2, 3, 2, 1]);
-- [1, 2, 3]
SELECT array_distinct(ARRAY[1, NULL, 1]);
-- [1, NULL]
{code}
See also
https://spark.apache.org/docs/latest/api/sql/index.html#array_distinct
--
This message was sent by Atlassian Jira
(v8.20.7#820007)