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

Signature

arrayContainsString('colName', valueToFind)

Usage Examples

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