ABS
Last updated
Last updated
Computes the absolute value of the given input.
ABS(X)
X
Type: numeric
A numeric value.
Type: same as input
The absolute value of X
.
-3
3
3
3
1 + 1
2
0
0
1.1
1.1
-1.1
1.1
-1 - 5
6
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
ABS(-3) AS abs_example
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
3