[ 
https://issues.apache.org/jira/browse/FLINK-31665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Hanyu Zheng updated FLINK-31665:
--------------------------------
    Description: 
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:

array_concat(array, array)

 

Arguments:

array: two ARRAY to be handled.

 

Returns:

An ARRAY. If the array is NULL, the result is NULL. 

Examples:

 

SELECT array_concat(array[1, 2, 3, null, 3], array[3]); 

-- [1,2,3,null,3,3]

 

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
>
>
> 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:
> array_concat(array, array)
>  
> Arguments:
> array: two ARRAY to be handled.
>  
> Returns:
> An ARRAY. If the array is NULL, the result is NULL. 
> Examples:
>  
> SELECT array_concat(array[1, 2, 3, null, 3], array[3]); 
> -- [1,2,3,null,3,3]
>  
> ARRAY_CONCAT doesn't have links to existing engines



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to