RAND

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

This is an alias for the RANDOM function.

Syntax

RAND()

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 RAND() as random_value
    FROM default_glue_catalog.upsolver_samples.orders_raw_data 
    WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
    LIMIT 5;

Query result

Last updated