Apache Pinot Docs
Search…
latest
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.
1
select FlightNum,
2
arrayReverseString(RandomAirports) AS reversedAirports,
3
RandomAirports
4
from airlineStats
5
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
6
limit 5
Copied!
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
Copy link