SQRT
Computes the square root of the given input.
Syntax
SQRT(X)
Arguments
X
X
Type: numeric
A numeric value.
Returns
Type: double
The square root of X
as a double
.
Note that if , then the function returns a null value.
Examples
X
Output
1
1.0
-1
null
0
0.0
10.5
3.24037034920393
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
SQRT(4) AS sqrt_example
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
Query result
sqrt_example
2.0
Last updated