Apache Pinot Docs
latest
Ask or search…
K
Comment on page

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.
select FlightNum,
arraySortString(RandomAirports) AS sortedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5
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