description |
---|
This section contains reference documentation for the arrayReverseString function. |
Reverses array of strings.
arrayReverseString('colName')
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 |