Links

REVERSE

Reverses the order of the characters within the given input string.

Syntax

REVERSE(STRING)

Arguments

STRING

Type: string
A sequence of characters.

Returns

Type: string
STRING with its characters in reverse order.

Examples

STRING
Output
string
gnirts
a
a
abc
cba
123
321

Transformation job example

SQL

CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT
customer_firstname,
REVERSE(customer_firstname) AS name_reversed
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE time_filter()
LIMIT 3;

Query result

customer_firstname
name_reversed
Alexander
rednaxelA
Thomas
samohT
Ryan
nayR
Last modified 6mo ago