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.

Computes a percentile state from a numeric value.

Analyze Syntax

func.percentile_hash(<value>)

Analyze Examples

func.percentile_hash(42.5)

┌─────────┐
│ (state)  │
└─────────┘

SQL Syntax

PERCENTILE_HASH(<value>)

SQL Examples

SELECT PERCENTILE_HASH(42.5);

┌────────────────────┐
│ (percentile state)  │
└────────────────────┘