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

Signature

arrayRemoveInt('colName', value)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select DivAirportIDs,
2
arrayRemoveInt(DivAirportIDs, 12892) AS value
3
from airlineStats
4
WHERE arraylength(DivAirportIDs) >= 2
5
AND arrayContainsInt(DivAirportIDs, 12892) = 1
6
limit 5
Copied!
DivAirportIDs
value
13891,12892
13891
13198,12892
13198
11066,12892
11066
13198,12892
13198
13891,12892
13891
Copy link