Skip to content

Built-in math functions

Nebula Graph supports the following built-in math functions:

Function Description
double abs(double x) Returns absolute value of the argument.
double floor(double x) Returns the largest integer value smaller than or equal to the argument. (Rounds down)
double ceil(double x) Returns the smallest integer greater than or equal to the argument. (Rounds up)
double round(double x) Returns the integer value nearest to the argument. Returns a number farther away from 0 if the argument is in the middle.
double sqrt(double x) Returns the square root of the argument.
double cbrt(double x) Returns the cubic root of the argument.
double hypot(double x, double y) Returns the hypotenuse of a right-angled triangle.
double pow(double x, double y) Returns the result of x raised by the yth power.
double exp(double x) Returns the value of e raised to the x power.
double exp2(double x) Returns 2 raised to the argument.
double log(double x) Returns natural logarithm of the argument.
double log2(double x) Returns the base-2 logarithm of the argument.
double log10(double x) Returns the base-10 logarithm of the argument.
double sin(double x) Returns sine of the argument.
double asin(double x) Returns inverse sine of the argument.
double cos(double x) Returns cosine of the argument.
double acos(double x) Returns inverse cosine of the argument.
double tan(double x) Returns tangent of the argument.
double atan(double x) Returns inverse tangent the argument.
double rand() Returns a random floating point number in the range from 0 (inclusive) to 1 (exclusive); i.e.[0,1).
int rand32(int min, int max) Returns a random 32-bit integer in [min, max). If you set only one argument, it is parsed as max and min is default to 0. If you set no argument, the system returns a random signed 32-bit integer.
int rand64(int min, int max) Returns a random 64-bit integer in [min, max). If you set only one argument, it is parsed as max and min is default to 0. If you set no argument, the system returns a random signed 64-bit integer.
collect() Puts all the collected values to a list.
avg() Returns the average value of the argument.
count() Returns the number of records.
max() Returns the maximum value.
min() Returns the minimum value.
std() Returns the population standard deviation.
sum() Returns the sum value.
bit_and() Bitwise AND.
bit_or() Bitwise OR.
bit_xor() Bitwise exclusive OR (XOR).
int size() Returns the number of elements in a list or a map.
int range(int start, int end, int step) Returns a list of integers from start (inclusive) to end (inclusive) in the specified steps. step is optional and default to 1.
int sign(double x) Returns the signum of the given number: 0 if the number is 0, -1 for any negative number, and 1 for any positive number.
double e() Returns the base of the natural logarithm, e (2.718281828459045).
double pi() Returns the mathematical constant pi (3.141592653589793).
double radians() Converts degrees to radians. radians(180) returns 3.141592653589793.

NOTE: If the argument is set to NULL, the output is undefined.


Last update: April 14, 2021