random function

Applies to: Databricks SQL 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 

Related functions

• randn function
• rand function
• randstr function
• uniform function