Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# ARRAY\$1CONCAT function
<a name="r_array_concat"></a>

Concatenates two arrays to create an array that contains all the elements in the first array followed by all the elements in the second array. The two arguments must be valid SUPER arrays.

## Syntax
<a name="r_array_concat-synopsis"></a>

```
ARRAY_CONCAT( array1, array2 )
```

## Arguments
<a name="r_array_concat-argument-arguments"></a>

 *array1*  
The value that specifies the first of the two arrays to concatenate.

 *array2*  
The value that specifies the second of the two arrays to concatenate.

## Return type
<a name="r_array_concat-return-type"></a>

The ARRAY\$1CONCAT function returns a SUPER data value.

## Example
<a name="r_array_concat-example"></a>

The following examples shows concatenation of two arrays of the same type and concatenation of two arrays of different types.

```
-- concatenating two arrays 
SELECT ARRAY_CONCAT(ARRAY(10001,10002),ARRAY(10003,10004));
              array_concat
------------------------------------
 [10001,10002,10003,10004]
(1 row)

-- concatenating two arrays of different types 
SELECT ARRAY_CONCAT(ARRAY(10001,10002),ARRAY('ab','cd'));
          array_concat
------------------------------
 [10001,10002,"ab","cd"]
(1 row)
```

## See also
<a name="r_array_concat-see-also"></a>
+ [ARRAY\$1UNION function](array_union.md)
+ [ARRAY\$1FLATTEN function](array_flatten.md)
+ [SPLIT\$1TO\$1ARRAY function](split_to_array.md)
+ [ARRAY\$1DISTINCT function](array_distinct.md)