Apache Pinot Docs
Search…
latest
arraySliceInt
This section contains reference documentation for the arraySliceInt function.
Returns the values in the array between the start and end positions.

Signature

arraySliceInt('colName', start, end)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select FlightNum,
2
arraySliceInt(DivAirportIDs, 0, 1) AS airports,
3
DivAirportIDs
4
from airlineStats
5
WHERE arraylength(DivAirportIDs) >= 2
6
limit 5
Copied!
FlightNum
airports
DivAirportIDs
1531
13891
13891,12892
19
14683
14683,14683
829
12339
12339,12339
24
13198
13198,10721
548
10721
10721,12478
Copy link