LOG
Return the logarithm of x to the given base.
Syntax
LOG(base, input)
Arguments
Name
Type
base
numeric
input
numeric
Returns
Double
Examples
base
input
Output
2
2
1.0
0.5
1
0.0
5
0.04
-2.0
10
0
'-Infinity'
1
10
'Infinity'
10
-2
nan()
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 base, input,
LOG(base, input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET base = 2,
input = 2
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
Query result
base
input
Output
2
2
1.0
Last updated