rand
function
Applies to: Databricks SQL Databricks Runtime
Returns a random value between 0 and 1. This function is a synonym for random function.
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clause更新しました 2024/12/06
rand
function Applies to: Databricks SQL Databricks Runtime
Returns a random value between 0 and 1. This function is a synonym for random function.
A DOUBLE
.
The function generates pseudo random results with independent and identically distributed (i.i.d.) uniformly distributed values in [0, 1).
This function is non-deterministic.
> SELECT rand();
0.9629742951434543
> SELECT rand(0);
0.8446490682263027
> SELECT rand(null);
0.8446490682263027