SORT_VALUES
Last updated
Last updated
Returns the values sorted in numerical order.
SORT_VALUES(descending, input)
descending
Boolean
false
input
numeric
Returns the same as the input.
false
null::double
null
false
array['b', 'c', 'a']
[a
, b
, c
]
true
array['b', 'c', 'a']
[c
, b
, a
]
false
null::double
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]
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::double
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
false
null::double
null