RAND
Returns a pseudo-random value in the range 0.0 <= x < 1.0.
This is an alias for the RANDOM
function.
Syntax
Returns
type: double
A pseudo-random value in the range 0.0 <= x < 1.0
The value will not change between different runs of the same task, i.e. if the result of this function makes the task fail, it will consistently fail.
Examples
Transformation job example
SQL
Query result
random_value
0.7221127479457028
0.2188878339486462
0.2127962883398693
0.12963758700859804
0.52354605630098234
Last updated