EXP
Computes where is Euler's number and is the given input.
Syntax
EXP(X)
Arguments
X
X
Type: numeric
A numeric value.
Returns
Type: double
Euler’s number raised to the power of X
.
Example
X
Output
1
2.7182818284590455
2
7.38905609893065
1 + 1
7.38905609893065
1.5
4.4816890703380645
-1
0.36787944117144233
-1.5
0.22313016014842982
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
EXP(1) AS exp_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
exp_example
2.7182818284590455
Last updated