arrayUnionInt
This section contains reference documentation for the arrayUnionInt function.
Create a union of two arrays of ints.
arrayUnionInt('colName1', 'colName2')
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 |
Last modified 1yr ago