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

Signature

arrayIndexOfString('colName', valueToFind)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select DivTailNums,
2
arrayIndexOfString(DivTailNums, 'N7713A') AS index
3
from airlineStats
4
WHERE arraylength(DivTailNums) >= 2
5
limit 5
Copied!
DivTailNums
index
N7713A,N7713A
0
N344AA,N344AA
-1
N7713A,N7713A
0
Copy link