RANDOM

Returns a pseudo-random value in the range 0.0 <= x < 1.0.

Syntax

RANDOM()

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

CREATE JOB function_operator_example
    ADD_MISSING_COLUMNS = true	
    AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
    SELECT RANDOM() as random_value
    FROM default_glue_catalog.upsolver_samples.orders_raw_data 
    WHERE time_filter()
    LIMIT 5;

Query result

random_value
0.7221127479457028
0.2188878339486462
0.2127962883398693
0.12963758700859804
0.52354605630098234