LN
Computes the natural logarithm where is the given input.
Syntax
LN(X)
Arguments
X
X
Type: numeric
A numeric value.
Returns
Type: double
The natural logarithm of X
.
Note that if , then the function returns a null value.
Examples
X
Output
1
0.0
0
null
2
0.6931471805599453
0.5
-0.6931471805599453
4 * 5
2.995732273553991
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
LN(1) AS ln_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
ln_example
0.0
Last updated