Teradata Package for Python Function Reference on VantageCloud Lake - array_union - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.
Teradata® Package for Python Function Reference on VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.11
- Published
- August 2026
- ft:locale
- en-US
- ft:lastEdition
- 2026-08-13
- dita:id
- TeradataPython_FxRef_Lake_2000
- Product Category
- Teradata Vantage
- teradataml.dataframe.sql.DataFrameColumn.array_union = array_union(self, other)
- DESCRIPTION:
Return the union of two arrays without duplicates.
PARAMETERS:
other:
Required Argument.
Specifies the other array to union with.
Types: ColumnExpression
RETURNS:
ColumnExpression
EXAMPLES:
>>> from teradataml import *
>>> load_example_data("array", "array_table")
# Create a DataFrame on 'array_table'.
>>> df = DataFrame("array_table")
>>> df
arr1 arr2 arr3
id
1 (10,20,30,40,50) (23,200,215,40,21) ('ab','bc','cd','ab','ef')
4 (180,28,38,48,58) (30,NULL,NULL,250,27) ('mn','no',NULL,'op','pq')
2 (150,25,35,45,55) (28,50,95,90,26) ('xy','yz','za','ab','xy')
6 (16,261,36,46,56) (29,170,160,46,25) ('uv','xy','ab','xy','yz')
3 (12,22,320,42,52) (25,22,140,200,23) ('pq','ab','ab','st','tu')
5 (14,24,34,44,54) (26,NULL,NULL,180,24) ('ij','jk',NULL,'kl','lm')
# Example 1: Get union of array columns 'arr1' and 'arr2'.
>>> res = df.assign(union_arr = df.arr1.array_union(df.arr2))
>>> res
arr1 arr2 arr3 union_arr
id
2 (150,25,35,45,55) (28,50,95,90,26) ('xy','yz','za','ab','xy') (150,25,35,45,55,28,50,95,90,26)
3 (12,22,320,42,52) (25,22,140,200,23) ('pq','ab','ab','st','tu') (12,22,320,42,52,25,140,200,23)
4 (180,28,38,48,58) (30,NULL,NULL,250,27) ('mn','no',NULL,'op','pq') (180,28,38,48,58,30,NULL,250,27)
6 (16,261,36,46,56) (29,170,160,46,25) ('uv','xy','ab','xy','yz') (16,261,36,46,56,29,170,160,25)
1 (10,20,30,40,50) (23,200,215,40,21) ('ab','bc','cd','ab','ef') (10,20,30,40,50,23,200,215,21)
5 (14,24,34,44,54) (26,NULL,NULL,180,24) ('ij','jk',NULL,'kl','lm') (14,24,34,44,54,26,NULL,180)