randn
function
Applies to: Databricks SQL Databricks Runtime
Returns a random value from a standard normal distribution.
Syntax
randn( [seed] )
Arguments
seed
: An optionalINTEGER
literal.
Returns
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.
Examples
> SELECT randn();
-0.3254147983080288
> SELECT randn(0);
1.1164209726833079
> SELECT randn(null);
1.1164209726833079