randn
function
Applies to: Databricks SQL Databricks Runtime
Returns a random value from a standard normal distribution.
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseAtualizado 11/10/2024
randn
function Applies to: Databricks SQL Databricks Runtime
Returns a random value from a standard normal distribution.
A DOUBLE
.
The function regenerates pseudo random results with independent and identically distributed (i.i.d.) values drawn from the standard normal distribution.
This function is non-deterministic.
> SELECT randn();
-0.3254147983080288
> SELECT randn(0);
1.1164209726833079
> SELECT randn(null);
1.1164209726833079