Aggregate Functions (Lakehouse v2)
This section provides reference information for the aggregate functions in PlaidCloud Lakehouse.
Functions
Section titled “Functions”- ANY_VALUE
- APPROX_COUNT_DISTINCT
- APPROX_TOP_K
- AVG
- BITMAP
- BOOL_OR
- CORR
- COUNT_IF
- COUNT
- COVAR_POP
- COVAR_SAMP
- DS_HLL_ACCUMULATE
- DS_HLL_COMBINE
- DS_HLL_COUNT_DISTINCT
- DS_HLL_ESTIMATE
- DS_THETA_COUNT_DISTINCT
- GROUP_CONCAT
- GROUPING_ID
- GROUPING
- HLL_RAW_AGG
- HLL_UNION_AGG
- HLL_UNION
- MANN_WHITNEY_U_TEST
- MAX_BY
- MAX
- MIN_BY
- MIN
- MULTI_DISTINCT_COUNT
- MULTI_DISTINCT_SUM
- PERCENTILE_APPROX_WEIGHT
- PERCENTILE_APPROX
- PERCENTILE_CONT
- PERCENTILE_DISC_LC
- PERCENTILE_DISC
- RETENTION
- STD
- STDDEV_POP
- STDDEV_SAMP
- STDDEV
- SUM_MAP
- SUM
- VAR_POP
- VAR_SAMP
- VARIANCE_POP
- VARIANCE_SAMP
- VARIANCE
- WINDOW_FUNNEL