Apache Pinot Docs
Search…
latest
arrayContainsInt
This section contains reference documentation for the arrayContainsInt function.
Checks if int value exists in array.

Signature

arrayContainsInt('colName', valueToFind)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select DivAirportIDs,
2
arrayContainsInt(DivAirportIDs, 14683) AS containsValue
3
from airlineStats
4
WHERE arraylength(DivAirportIDs) >= 2
5
limit 5
Copied!
DivAirportIDs
containsValue
13891,12892
false
14683,14683
true
12339,12339
false
13487,13930
false
13029,11292
false
Copy link