| description |
|---|
This section contains reference documentation for the arrayUnionInt function. |
Create a union of two arrays of ints.
arrayUnionInt('colName1', 'colName2')
These examples are based on the Hybrid Quick Start.
select DivWheelsOffs,
DivWheelsOns,
arrayUnionInt(DivWheelsOffs, DivWheelsOns) AS unionIds
from airlineStats
WHERE arraylength(DivWheelsOffs) >= 2
limit 5| DivWheelsOffs | DivWheelsOns | unionIds |
|---|---|---|
| 1453,1731 | 1415,1623 | 1453,1731,1415,1623 |
| 1908,1758 | 1339,2310 | 1908,1758,1339,2310 |
| 1453,1731 | 1415,1623 | 1453,1731,1415,1623 |
| 1908,1758 | 1339,2310 | 1908,1758,1339,2310 |