[
https://issues.apache.org/jira/browse/FLINK-31622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jackylau updated FLINK-31622:
-----------------------------
Description:
array_append(array, element) - Append the element at the end of the array.
Syntax:
array_append(array, element)
Arguments:
array: An ARRAY to be handled.
Returns:
Append the element at the end of the array.
This function does not return null when the elements are null. It appends null
at the end of the array. But returns null if the array is null.
{code:sql}
> SELECT array_append(array(3, 2, 1), 1);
3 {code}
See also
spark not in docs but in code.
snowflake https://docs.snowflake.com/en/sql-reference/functions/array_append
postgresql
[https://www.postgresql.org/docs/12/functions-array.html#ARRAY-FUNCTIONS-TABLE]
> Add ARRAY_APPEND supported in SQL & Table API
> ---------------------------------------------
>
> Key: FLINK-31622
> URL: https://issues.apache.org/jira/browse/FLINK-31622
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.18.0
> Reporter: jackylau
> Priority: Major
> Fix For: 1.18.0
>
>
> array_append(array, element) - Append the element at the end of the array.
> Syntax:
> array_append(array, element)
> Arguments:
> array: An ARRAY to be handled.
> Returns:
> Append the element at the end of the array.
> This function does not return null when the elements are null. It appends
> null at the end of the array. But returns null if the array is null.
> {code:sql}
> > SELECT array_append(array(3, 2, 1), 1);
> 3 {code}
> See also
> spark not in docs but in code.
> snowflake https://docs.snowflake.com/en/sql-reference/functions/array_append
> postgresql
> [https://www.postgresql.org/docs/12/functions-array.html#ARRAY-FUNCTIONS-TABLE]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
