jackylau created FLINK-31118: -------------------------------- Summary: Add ARRAY_UNION supported in SQL & Table API Key: FLINK-31118 URL: https://issues.apache.org/jira/browse/FLINK-31118 Project: Flink Issue Type: Sub-task Components: Table SQL / Planner Affects Versions: 1.18.0 Reporter: jackylau Fix For: 1.18.0
Remove all elements that equal to element from array. Syntax: array_remove(array) Arguments: array: An ARRAY to be handled. Returns: An ARRAY. If value is NULL, the result is NULL. Examples: {code:sql} > SELECT array_union(array(1, 2, 3), array(1, 3, 5)); [1,2,3,5] {code} See also spark https://spark.apache.org/docs/latest/api/sql/index.html#array_union presto https://prestodb.io/docs/current/functions/array.html -- This message was sent by Atlassian Jira (v8.20.10#820010)