| AVG([number] x) |
Double |
Returns the average value of x. |
| "CORR"([number] x, [number] y) |
Double |
Calculates the covariance of the values in x and y. Function name must be enclosed in double quotes. |
| COUNT(*) |
BIGINT |
Gives the total number of records. |
| COUNT(DISTINCT [field name] givenfield) |
BIGINT |
Gives the number of distinct values in the field named givenfield. |
| MAX([number] x) |
Same as input |
Returns the maximum value of x. |
| MAX([timetype] giventime) |
Same as input |
Returns the latest value of giventime. |
| MIN([number] x) |
Same as input |
Returns the minimum value of x. |
| MIN([timetype] giventime) |
Same as input |
Returns the earliest value of giventime. |
| NDV([field name] givenfield) |
BIGINT |
Fast and memory efficient approximate COUNT(DISTINCT) alternative using HyperLogLog. |
| STDDEV_POP([number] x) |
Double |
Takes the population standard deviation of values of x. |
| STDDEV([number] x) |
Double |
Takes the sample standard deviation of values of x. |
| SUM([number] x) |
Same as input |
Returns the sum of values of x. |
| SUM([timeinterval] giveninterval) |
Same as input |
Returns the sum of values of giveninterval. |
| VAR_POP([number] x) |
Double |
Takes the population variance of values of x. |
| VARIANCE([number] x) |
Double |
Takes the sample variance of values of x. |