Apache Pinot Docs
Search…
latest
arrayRemoveString
This section contains reference documentation for the arrayRemoveString function.
Removes value from array of strings.

Signature

arrayRemoveString('colName', value)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select RandomAirports,
2
arrayRemoveString(RandomAirports, 'SEA') AS value
3
from airlineStats
4
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
5
limit 5
Copied!
DivAirportIDs
value
SEA,PSC
PSC
SEA,PSC,PHX,MSY
PSC,PHX,MSY
SEA,PSC,PHX,MSY
PSC,PHX,MSY
SEA,PSC
PSC
SEA,PSC
PSC
Copy link