Apache Pinot Docs
Search…
latest
arrayIndexOfInt
This section contains reference documentation for the arrayIndexOfInt function.
Finds the last index of the given value in the array starting at the given index.

Signature

arrayIndexOfInt('colName', valueToFind)

Usage Examples

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