| General window | |
| ANY_VALUE | |
| AVG | |
| CONDITIONAL_CHANGE_EVENT | |
| CONDITIONAL_TRUE_EVENT | |
| CORR | |
| COUNT | |
| COUNT_IF | |
| COVAR_POP | |
| COVAR_SAMP | |
| INTERPOLATE_BFILL, INTERPOLATE_FFILL, INTERPOLATE_LINEAR | |
| LISTAGG | Uses WITHIN GROUP syntax. |
| MAX | |
| MEDIAN | |
| MIN | |
| MODE | |
| PERCENTILE_CONT | Uses WITHIN GROUP syntax. |
| PERCENTILE_DISC | Uses WITHIN GROUP syntax. |
| RATIO_TO_REPORT | |
| STDDEV, STDDEV_SAMP | STDDEV and STDDEV_SAMP are aliases. |
| STDDEV_POP | |
| SUM | |
| VAR_POP | |
| VAR_SAMP | |
| VARIANCE_POP | Alias for VAR_POP. |
| VARIANCE , VARIANCE_SAMP | Alias for VAR_SAMP. |
| Ranking | |
| CUME_DIST | |
| DENSE_RANK | |
| FIRST_VALUE | |
| LAG | |
| LAST_VALUE | |
| LEAD | |
| NTH_VALUE | |
| NTILE | |
| PERCENT_RANK | Supports only RANGE BETWEEN window frames without explicit offsets. |
| RANK | |
| ROW_NUMBER | |
| Bitwise aggregation | |
| BITAND_AGG | |
| BITOR_AGG | |
| BITXOR_AGG | |
| Boolean aggregation | |
| BOOLAND_AGG | |
| BOOLOR_AGG | |
| BOOLXOR_AGG | |
| Hash | |
| HASH_AGG | |
| Semi-structured data aggregation | |
| ARRAY_AGG | |
| OBJECT_AGG | |
| Counting distinct values | |
| ARRAY_UNION_AGG | |
| ARRAY_UNIQUE_AGG | |
| Linear regression | |
| REGR_AVGX | |
| REGR_AVGY | |
| REGR_COUNT | |
| REGR_INTERCEPT | |
| REGR_R2 | |
| REGR_SLOPE | |
| REGR_SXX | |
| REGR_SXY | |
| REGR_SYY | |
| Statistics and probability | |
| KURTOSIS | |
Cardinality estimation
(using HyperLogLog) | |
| APPROX_COUNT_DISTINCT | Alias for HLL. |
| HLL | |
| HLL_ACCUMULATE | |
| HLL_COMBINE | |
| HLL_ESTIMATE | Not an aggregate function; uses scalar input from HLL_ACCUMULATE or HLL_COMBINE. |
| HLL_EXPORT | |
| HLL_IMPORT | |
Similarity estimation
(using MinHash) | |
| APPROXIMATE_JACCARD_INDEX | Alias for APPROXIMATE_SIMILARITY. |
| APPROXIMATE_SIMILARITY | |
| MINHASH | |
| MINHASH_COMBINE | |
Frequency estimation
(using Space-Saving) | |
| APPROX_TOP_K | |
| APPROX_TOP_K_ACCUMULATE | |
| APPROX_TOP_K_COMBINE | |
| APPROX_TOP_K_ESTIMATE | Not an aggregate function; uses scalar input from APPROX_TOP_K_ACCUMULATE or APPROX_TOP_K_COMBINE. |
Percentile estimation
(using t-Digest) | |
| APPROX_PERCENTILE | |
| APPROX_PERCENTILE_ACCUMULATE | |
| APPROX_PERCENTILE_COMBINE | |
| APPROX_PERCENTILE_ESTIMATE | Not an aggregate function; uses scalar input from APPROX_PERCENTILE_ACCUMULATE or APPROX_PERCENTILE_COMBINE. |