Builtin modules and functions
We provide a wide range of built-in functions for users to use. The following is a list of built-in functions. Simply write import greptime or from greptime import * at the beginning of your script to use them.
Vector functions
| Function | Description |
|---|---|
pow(v0, v1) | Raise a number v0 to a power of v1. |
clip(v0, v1, v2) | Clip all elements in a vector v0 to a range between vectors v1 and v2. |
diff(v0) | Calculate the difference between adjacent elements in a vector v0. |
mean(v0) | Calculate the mean of a vector v0. |
polyval(v0, v1) | Evaluate a polynomial v0 at points v1. similar to numpy.polyval. |
argmax(v0) | Return the index of the maximum value in a vector v0. similar to numpy.argmax. |
argmin(v0) | Return the index of the minimum value in a vector v0. similar to numpy.argmin. |
percentile | Calculate the q-th percentile of a vector v0. similar to numpy.percentile. |
scipy_stats_norm_cdf | Calculate the cumulative distribution function for the normal distribution. similar to scipy.stats.norm.cdf. |
scipy_stats_norm_pdf | Calculate the probability density function for the normal distribution. similar to scipy.stats.norm.pdf. |
Math functions
| Function | Description |
|---|---|
sqrt(v) | Calculate the square root of a number v. |
sin(v) | Calculate the sine of a number v. |
cos(v) | Calculate the cosine of a number v. |
tan(v) | Calculate the tangent of a number v. |
asin(v) | Calculate the arcsine of a number v. |
acos(v) | Calculate the arccosine of a number v. |
atan(v) | Calculate the arctangent of a number v. |
floor(v) | Calculate the floor of a number v. |
ceil(v) | Calculate the ceiling of a number v. |
round(v) | Calculate the nearest integer of a number v. |
trunc(v) | Calculate the truncated integer of a number v. |
abs(v) | Calculate the absolute value of a number v. |
signum(v) | Calculate the sign(gives 1.0/-1.0) of a number v. |
exp(v) | Calculate the exponential of a number v. |
ln(v) | Calculate the natural logarithm of a number v. |
log2(v) | Calculate the base-2 logarithm of a number v. |
log10(v) | Calculate the base-10 logarithm of a number v. |
Utility functions & Aggregation functions
These Functions are bound from DataFusion
| Function | Description |
|---|---|
random(len) | Generate a random vector with length len. |
approx_distinct(v0) | Calculate the approximate number of distinct values in a vector v0. |
median(v0) | Calculate the median of a vector v0. |
approx_percentile_cont(values, percent) | Calculate the approximate percentile of a vector values at a given percentage percent. |
array_agg(v0) | Aggregate values into an array. |
avg(v0) | Calculate the average of a vector v0. |
correlation(v0, v1) | Calculate the Pearson correlation coefficient of a vector v0 and a vector v1. |
count(v0) | Calculate the count of a vector v0. |
covariance(v0, v1) | Calculate the covariance of a vector v0 and a vector v1. |
covariance_pop(v0, v1) | Calculate the population covariance of a vector v0 and a vector v1. |
max(v0) | Calculate the maximum of a vector v0. |
min(v0) | Calculate the minimum of a vector v0. |
stddev(v0) | Calculate the sample standard deviation of a vector v0. |
stddev_pop(v0) | Calculate the population standard deviation of a vector v0. |
sum(v0) | Calculate the sum of a vector v0. |
variance(v0) | Calculate the sample variance of a vector v0. |
variance_pop(v0) | Calculate the population variance of a vector v0. |