EXP

Computes $e^x$ where $e$​ is Euler's number and $x$​ is the given input.

Syntax

EXP(X)

Arguments

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