| Function Name | Description |
|---|---|
| APPROX_COUNT_DISTINCT | Returns the approximate number of unique, non-null values in a column. |
| AVG | Computes the average of a set of values. |
| BIT_AND | Returns the bitwise AND of non-NULL input values. |
| BIT_OR | Returns the bitwise OR of non-NULL input values. |
| CORR | Calculates the Pearson correlation coefficient of the values expression1 and expression2. The function name must be enclosed in double quotes (“CORR”). |
| COUNT | Returns the total number of records for the specified expression. |
| COVAR_POP | Returns the population covariance for non-NULL pairs across all input values. |
| COVAR_SAMP | Returns the sample covariance for non-NULL pairs across all input values. |
| HLL | Uses HyperLogLog to return an approximation of the distinct cardinality of the input. |
| LISTAGG | Concatenates a group of rows into a list of strings and places a separator between them. |
| MAX | Returns the maximum value among the non-NULL input expressions. |
| MIN | Returns the minimum value among the non-NULL input expressions. |
| NDV | Returns an approximate distinct value number, similar to COUNT(DISTINCT col). NDV can return results faster than using the combination of COUNT and DISTINCT while using a constant amount of memory, resulting in less memory usage for columns with high cardinality. |
| STDDEV | Returns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL. |
| STDDEV_POP | Returns the population standard deviation (square root of variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL. |
| STDDEV_SAMP | Returns the sample standard deviation (square root of sample variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL. |
| SUM | Returns the sum of non-NULL input expressions. |
| VAR_POP | Returns the population variance of non-NULL records. |
| VAR_SAMP | Returns the sample variance of non-NULL records. |