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

Signature

arraySliceString('colName', start, end)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select FlightNum,
2
arraySliceString(RandomAirports, 0, 2) AS airports,
3
RandomAirports
4
from airlineStats
5
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
6
limit 5
Copied!
FlightNum
airports
RandomAirports
671
SEA,PSC
SEA,PSC,PHX,MSY
1767
SEA,PSC
SEA,PSC,PHX
2522
SEA,PSC
SEA,PSC
424
SEA,PSC
SEA,PSC,PHX,MSY
3162
SEA,PSC
SEA,PSC,PHX,MSY
Copy link