Apache Pinot Docs
latest
Ask or search…
K

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.
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