EXP

Computes exe^x where ee​ is Euler's number and xx​ 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

XOutput

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