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() is a synonym for CEILING().

CEILING

ceiling(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.

FLOOR

floor(col)

Returns the largest integer value not greater than X.

LN

ln(col)

Returns the natural logarithm of a double value.

LOG

log(col)

or

log(b, col)

If called with one argument, the function returns the decimal logarithm of X. If X is less than or equal to 0, the function returns nil; if called with two arguments, the function returns the base B logarithm of X. Returns nil if X is less than or equal to 0, or if B is less than or equal to 1.

MOD

mod(col1, col2)

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

PI

pi()

Returns the value of π (pi).

POW

POW() is a synonym for POWER().

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.

COT

cot(col)

Returns the cotangent of a number.

RADIANS

radians(col)

converted from degrees to radians.

DEGREES

degrees(col)

converted from radians to degrees

CONV

conv(N,from_base,to_base)

converts numbers between different number bases. Returns a string representation of the number N, converted from base from_base to base to_base. Returns NULL if any argument is NULL. The argument N is interpreted as an integer, but may be specified as an integer or a string. The minimum base is 2 and the maximum base is 36.

ekuiper> select conv('a',16,2);
        -> '1010'
ekuiper> select conv('6E',18,8);
        -> '172'
ekuiper> select conv(-17,10,-18);
        -> '-H'