Apache Pinot Docs
Search…
latest
arraySortString
This section contains reference documentation for the arraySortString function.
Sorts array of strings.

Signature

arraySortString('colName')

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select FlightNum,
2
arraySortString(RandomAirports) AS sortedAirports,
3
RandomAirports
4
from airlineStats
5
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
6
limit 5
Copied!
FlightNum
sortedAirports
RandomAirports
3846
PSC,SEA
SEA,PSC
3635
MSY,PHX,PSC,SEA
SEA,PSC,PHX,MSY
429
MSY,PHX,PSC,SEA
SEA,PSC,PHX,MSY
1206
PSC,SEA
SEA,PSC
5300
PSC,SEA
SEA,PSC
Copy link