ekuiper-new/docs/en_US/sqls/functions/mathematical_functions.md

Mathematical Functions

Mathematical functions perform many of the common mathematical operations. They take numeric input and return numeric output.

ABS

abs(col)

The absolute value of a value.

ACOS

acos(col)

The inverse cosine of a number of radians.

ASIN

asin(col)

The inverse sine of a number of radians.

ATAN

atan(col)

The inverse tangent of a number of radians.

ATAN2

atan2(col1, col2)

The angle, in radians, between the positive x-axis and the (x, y) point defined in the two arguments.

BITAND

bitand(col1, col2)

Performs a bitwise AND on the bit representations of the two Int(-converted) arguments.

BITOR

bitor(col1, col2)

Performs a bitwise OR of the bit representations of the two arguments.

BITXOR

bitxor(col1, col2)

Performs a bitwise XOR on the bit representations of the two Int(-converted) arguments.

BITNOT

bitnot(col1)

Performs a bitwise NOT on the bit representations of the Int(-converted) argument.

CEIL

ceil(col)

The smallest integer value that is greater than or equal to the argument.

COS

cos(col)

The cosine of a number of radians.

COSH

cosh(col)

The hyperbolic cosine of a number.

EXP

exp(col)

Returns Euler's number e raised to the power of a double value.

LN

ln(col)

Returns the natural logarithm of a double value.

LOG

log(col)

Returns the base 10 logarithm of a double value.

MOD

mod(col1, col2)

Returns the remainder of the division of the first argument by the second argument.

POWER

power(col1, col2)

Returns the value of the first argument raised to the power of the second argument.

RAND

rand()

Returns a random number between 0.0 (inclusive) and 1.0 (exclusive).

ROUND

round(col)

Returns the closest BIGINT value to the argument.

SIGN

sign(col)

Returns the signum function of the argument. When the sign of the argument is positive, 1 is returned. When the sign of the argument is negative, -1 is returned. If the argument is 0, 0 is returned.

SIN

sin(col)

The sine of a numbmulti_column_functions.mder in radians.

SINH

sinh(col)

The hyperbolic sine of a number.

SQRT

sqrt(col)

Returns the positive square root of a double value.

TAN

tan(col)

The tangent of a number of radians.

TANH

tanh(col)

The hyperbolic tangent of a number.