SORT_VALUES
Returns the values sorted in dictionary order.
Syntax
SORT_VALUES(descending, input)
Arguments
Name
Type
Description
Default Value
descending
Boolean
false
input
string
Returns
Returns a string
value.
Examples
descending
input
Output
false
null::string
null
false
array['b', 'c', 'a']
[a
, b
, c
]
true
array['b', 'c', 'a']
[c
, b
, a
]
false
null::string
null
false
array[4, 2, 14]
[2, 4, 14]
false
array[1000.1, 1.2, 0.1]
[0.1, 1.2, 1000.1]
true
array[4, 2, 14]
[14, 4, 2]
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 descending, input,
SORT_VALUES(false, input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET descending = false,
input = null::string
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
Query result
descending
input
Output
false
null::string
null
Last updated