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

arrayReverseString

This section contains reference documentation for the arrayReverseString function.
Reverses array of strings.

Signature

arrayReverseString('colName')

Usage Examples

These examples are based on the Hybrid Quick Start.
select FlightNum,
arrayReverseString(RandomAirports) AS reversedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5
FlightNum
reversedAirports
RandomAirports
1206
PSC,SEA
SEA,PSC
5300
PSC,SEA
SEA,PSC
3359
MSY,PHX,PSC,SEA
SEA,PSC,PHX,MSY
1023
PHX,PSC,SEA
SEA,PSC,PHX
963
MSY,PHX,PSC,SEA
SEA,PSC,PHX,MSY