PERCENTILE_APPROX_RAW
Use the PERCENTILE_APPROX_RAW percentile function in PlaidCloud Lakehouse. Returns an approximate percentile value from a precomputed percentile state.
Percentile Functions
This section provides reference information for the percentile functions in PlaidCloud Lakehouse.
PERCENTILE_CONT
Learn how to use the PERCENTILE_CONT percentile function in PlaidCloud Lakehouse. Returns an interpolated percentile value based on a continuous distribution.
PERCENTILE_DISC
Use the PERCENTILE_DISC percentile function in PlaidCloud Lakehouse. Returns the smallest value whose cumulative distribution is >= the specified percentile.
PERCENTILE_EMPTY
Learn how to use the PERCENTILE_EMPTY percentile function in PlaidCloud Lakehouse. Returns an empty percentile state for initialization.
PERCENTILE_HASH
Learn how to use the PERCENTILE_HASH percentile function in PlaidCloud Lakehouse. Computes a percentile state from a numeric value - with syntax and examples.
PERCENTILE_UNION
Learn how to use the PERCENTILE_UNION percentile function in PlaidCloud Lakehouse. Returns the union of multiple percentile states - with syntax and examples.