Mathematical functions - Amazon Timestream

Mathematical functions

Timestream supports the following mathematical functions.

Function Output data type Description

abs(x)

[same as input]

Returns the absolute value of x.

cbrt(x)

double

Returns the cube root of x.

ceiling(x) or ceil(x)

[same as input]

Returns x rounded up to the nearest integer.

cosine_similarity(x,y)

double

Returns the cosine similarity between the sparse vectors x and y.

degrees(x)

double

Converts angle x in radians to degrees.

e()

double

Returns the constant Euler's number.

exp(x)

double

Returns Euler's number raised to the power of x.

floor(x)

[same as input]

Returns x rounded down to the nearest integer.

from_base(string,radix)

bigint

Returns the value of string interpreted as a base-radix number.

ln(x)

double

Returns the natural logarithm of x.

log2(x)

double

Returns the base 2 logarithm of x.

log10(x)

double

Returns the base 10 logarithm of x.

mod(n,m)

[same as input]

Returns the modulus (remainder) of n divided by m.

pi()

double

Returns the constant Pi.

pow(x, p) or power(x, p)

double

Returns x raised to the power of p.

radians(x)

double

Converts angle x in degrees to radians.

rand() or random()

double

Returns a pseudo-random value in the range 0.0 1.0.

random(n)

[same as input]

Returns a pseudo-random number between 0 and n (exclusive).

round(x)

[same as input]

Returns x rounded to the nearest integer.

round(x,d)

[same as input]

Returns x rounded to d decimal places.

sign(x)

[same as input]

Returns the signum function of x, that is:

  • 0 if the argument is 0

  • 1 if the argument is greater than 0

  • -1 if the argument is less than 0.

For double arguments, the function additionally returns:

  • NaN if the argument is NaN

  • 1 if the argument is +Infinity

  • -1 if the argument is -Infinity.

sqrt(x)

double

Returns the square root of x.

to_base(x, radix) 

varchar

Returns the base-radix representation of x.

truncate(x)

double

Returns x rounded to integer by dropping digits after decimal point.

acos(x)

double

Returns the arc cosine of x.

asin(x) 

double

Returns the arc sine of x.

atan(x) 

double

Returns the arc tangent of x.

atan2(y, x)

double

Returns the arc tangent of y / x.

cos(x)

double

Returns the cosine of x.

cosh(x)

double

Returns the hyperbolic cosine of x.

sin(x) 

double

Returns the sine of x.

tan(x)

double

Returns the tangent of x.

tanh(x)

double

Returns the hyperbolic tangent of x.

infinity()

double

Returns the constant representing positive infinity.

is_finite(x)

boolean

Determine if x is finite.

is_infinite(x)

boolean

Determine if x is infinite.

is_nan(x)

boolean

Determine if x is not-a-number.

nan()

double

Returns the constant representing not-a-number.