TANH
Evaluates the hyperbolic tangent of the given hyperbolic angle.
Syntax
TANH(X)
Arguments
X
X
Type: numeric
A numeric value representing the magnitude of a hyperbolic angle.
Returns
Type: double
The hyperbolic tangent of X
.
Examples
X
Output
1
0.7615941559557649
-1
-0.7615941559557649
0
0
0.5
0.46211715726000974
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
TANH(1) AS tanh_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
tanh_example
0.7615941559557649
Last updated