POWER
Raises the first input to the power of the second input.
Syntax
POWER(X, P)
Arguments
X
X
Type: numeric
A numeric value.
P
P
Type: numeric
A numeric value.
Returns
Type: double
X
raised to the power of P
.
Examples
X
P
Output
1
1
1.0
2
2
4.0
-1
2
1.0
-2
-2
0.25
0.5
0.5
0.7071067811865476
0.5
0
1.0
0
0
1.0
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
POWER(2, 2) AS power_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
power_example
4.0
Last updated