Share via

random function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns a random value between 0 and 1. This function is a synonym for rand function.

Syntax

random( [ seed ] )

Arguments

  • seed: An optional INTEGER literal.

Returns

A DOUBLE.

The function generates pseudo random results with independent and identically distributed uniformly distributed values in [0, 1).

This function is non-deterministic.

Examples

> SELECT random();
 0.9629742951434543

> SELECT random(0);
 0.8446490682263027

> SELECT random(null);
 0.8446490682263027