[
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:
{{}}
{code:java}
Flink SQL> SELECT array_concat(array[1, 2, 3, null, 3], array[3], array[5]);
[1, 2, 3, null, 3, 3]{code}
see also:
Google Cloud BigQuery:
[https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_concat]
was:
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]
> 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:
> {{}}
> {code:java}
> Flink SQL> SELECT array_concat(array[1, 2, 3, null, 3], array[3], array[5]);
> [1, 2, 3, null, 3, 3]{code}
> 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)
