Trigonometric Functions

SIN( <expr> )

Calculate the sine of the given argument, which must be in radians.

> select sin(randians(90));
1

SINH( <expr> )

Calculate the hyperbolic sine of its argument.

Support datatype: INT/DOUBLE

> select sinh(-0.2);
-0.20133600254109402

COS( <expr> )

Calculate the cosine of the given argument, which must be in radians.

> select cos(degrees(45));
0.7071067811865476

COSH( <expr> )

Calculate the hyperbolic cosine of its argument.

> select cosh(-5)
74.20994852478785

ACOSH( <expr> )

Calculate the hyperbolic cosine of its argument.

> select acosh(1.5)
0.9624236501192069

TANH( <expr> )

Computes the hyperbolic tangent of the expr

> select tanh(3.5);
0.9981778976111987

COT( <expr> )

Calculate the cotangent of the given argument, which must be in radians.

> select cot(100);
-1.702956919426469

DEGREES( <expr> )

Converts radians to degrees.

> select degrees(1);
57.29577951308232

RADIANS( <expr> )

Converts degrees to radians.

> select radians(1);
1.0471975511965976

PI( )

Returns the value of pi as float

> select pi() 
3.141592654

Last updated

#930: Cross account hive GCP

Change request updated