Apache Pinot Docs
Search…
latest
arrayUnionInt
This section contains reference documentation for the arrayUnionInt function.
Create a union of two arrays of ints.

Signature

arrayUnionInt('colName1', 'colName2')

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select DivWheelsOffs,
2
DivWheelsOns,
3
arrayUnionInt(DivWheelsOffs, DivWheelsOns) AS unionIds
4
from airlineStats
5
WHERE arraylength(DivWheelsOffs) >= 2
6
limit 5
Copied!
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
Copy link