[
https://issues.apache.org/jira/browse/FLINK-31665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanyu Zheng updated FLINK-31665:
--------------------------------
Description:
This is an implementation of ARRAY_CONCEPT
The array_concat() function concatenates at least one array, creating an array
that contains all the elements in the first array followed by all the elements
in the second array ... followed by all the elements in the n array.
h3. Brief change log
ARRAY_CONCAT for Table API and SQL
Syntax:
{{ARRAY_CONCAT(arr1, tail...) }}
Arguments:
array: at least one ARRAY to be handled.
Returns:
The function returns NULL if any input argument is NULL.
Examples:
{{Flink SQL> SELECT array_concat(array[1, 2, 3, null, 3], array[3], array[5]);
[1, 2, 3, null, 3, 3]}}
see also:
Google Cloud BigQuery:
[https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_concat]
was:
The array_concat() function concatenates two arrays, creating an array that
contains all the elements in the first array followed by all the elements in
the second array.
This is an implementation of ARRAY_CONCAT
Brief change log
ARRAY_CONCAT for Table API and SQL
Syntax:
{code:java}
ARRAY_CONCAT(arr1, arr2, tail...){code}
Arguments:
array: at least two ARRAY to be handled.
Returns:
An ARRAY. If all arrays are NULL, the result is NULL.
Examples:
{code:java}
SELECT array_concat(array[1, 2, 3, null, 3], array[3], array[5]);
– [1, 2, 3, null, 3, 3, 5]
{code}
ARRAY_CONCAT doesn't have links to existing engines
> Add ARRAY_CONCAT supported in SQL & Table API
> ---------------------------------------------
>
> Key: FLINK-31665
> URL: https://issues.apache.org/jira/browse/FLINK-31665
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.18.0
> Reporter: jackylau
> Assignee: Hanyu Zheng
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.18.0
>
>
> This is an implementation of ARRAY_CONCEPT
> The array_concat() function concatenates at least one array, creating an
> array that contains all the elements in the first array followed by all the
> elements in the second array ... followed by all the elements in the n array.
> h3. Brief change log
> ARRAY_CONCAT for Table API and SQL
> Syntax:
> {{ARRAY_CONCAT(arr1, tail...) }}
> Arguments:
> array: at least one ARRAY to be handled.
> Returns:
> The function returns NULL if any input argument is NULL.
> Examples:
> {{Flink SQL> SELECT array_concat(array[1, 2, 3, null, 3], array[3],
> array[5]); [1, 2, 3, null, 3, 3]}}
> see also:
> Google Cloud BigQuery:
> [https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_concat]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
