Trigonometric Functions

Pinot provides standard trigonometric functions that operate on double values. Angles are expressed in radians unless otherwise noted. Use the radians() function to convert degrees to radians before passing values to trigonometric functions.

sin

sin(col)

Returns the sine of the given angle (in radians).

SELECT sin(radians(30))
FROM myTable
-- Returns 0.49999999999999994

cos

cos(col)

Returns the cosine of the given angle (in radians).

SELECT cos(radians(60))
FROM myTable
-- Returns 0.5000000000000001

tan

tan(col)

Returns the tangent of the given angle (in radians).

SELECT tan(radians(45))
FROM myTable
-- Returns 0.9999999999999999

cot

cot(col)

Returns the cotangent of the given angle (in radians), computed as 1 / tan(col).

SELECT cot(radians(45))
FROM myTable
-- Returns 1.0000000000000002

asin

asin(col)

Returns the arc sine of a value, in radians. The input must be between -1 and 1.

SELECT asin(0.5)
FROM myTable
-- Returns 0.5235987755982989 (pi/6)

acos

acos(col)

Returns the arc cosine of a value, in radians. The input must be between -1 and 1.

SELECT acos(0.5)
FROM myTable
-- Returns 1.0471975511965979 (pi/3)

atan

atan(col)

Returns the arc tangent of a value, in radians.

SELECT atan(1)
FROM myTable
-- Returns 0.7853981633974483 (pi/4)

atan2

atan2(y, x)

Returns the angle in radians between the positive x-axis and the point (x, y), using the signs of both arguments to determine the quadrant.

SELECT atan2(1, 1)
FROM myTable
-- Returns 0.7853981633974483 (pi/4)

sinh

sinh(col)

Returns the hyperbolic sine of the given value.

SELECT sinh(1)
FROM myTable
-- Returns 1.1752011936438014

cosh

cosh(col)

Returns the hyperbolic cosine of the given value.

SELECT cosh(1)
FROM myTable
-- Returns 1.5430806348152437

tanh

tanh(col)

Returns the hyperbolic tangent of the given value.

SELECT tanh(1)
FROM myTable
-- Returns 0.7615941559557649

asinh

asinh(col)

Returns the inverse hyperbolic sine of the given value.

SELECT asinh(0)
FROM myTable
-- Returns 0.0

acosh

acosh(col)

Returns the inverse hyperbolic cosine of the given value. The input must be greater than or equal to 1.

SELECT acosh(1)
FROM myTable
-- Returns 0.0

atanh

atanh(col)

Returns the inverse hyperbolic tangent of the given value. The input must be between -1 and 1.

SELECT atanh(0.46211715726000974)
FROM myTable
-- Returns approximately 0.5

degrees

degrees(col)

Converts an angle measured in radians to an approximately equivalent angle measured in degrees.

SELECT degrees(3.141592653589793)
FROM myTable
-- Returns 180.0

radians

radians(col)

Converts an angle measured in degrees to an approximately equivalent angle measured in radians.

SELECT radians(180)
FROM myTable
-- Returns 3.141592653589793