Apache Pinot Docs
Search…
latest
arrayDistinctInt
This section contains reference documentation for the arrayDistinctInt function.
Returns unique values in an array of ints.

Signature

arrayDistinctInt('colName')

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select DivAirportIDs,
2
arrayDistinctInt(DivAirportIDs) AS unique
3
from airlineStats
4
WHERE arraylength(DivAirportIDs) >= 2
5
limit 5
Copied!
DivAirportIDs
unique
15016,11066
15016,11066
10620,14869
10620,14869
13891,12892
13891,12892
12264,10397
12264,10397
11066,12892
11066,12892
Copy link