RAND (Lakehouse v2)

Returns a random floating-point value between 0 (inclusive) and 1 (exclusive).

Analyze Syntax

func.rand([<seed>])

Analyze Examples

func.rand()

┌───────────┐
│ 0.6347...  │
└───────────┘

SQL Syntax

RAND([<seed>])

SQL Examples

SELECT RAND();

┌───────────┐
│ 0.6347...  │
└───────────┘