This page explains how to use the rand function in APL.
rand
function in APL to generate pseudo-random numbers. This function is useful when you want to introduce randomness into your queries. For example, to sample a subset of data, generate test data, or simulate probabilistic scenarios.
Splunk SPL users
random()
function returns a pseudo-random integer between 0 and 2^31-1. You often divide this value to produce a float between 0 and 1. In APL, the rand()
function directly returns a float in the range [0, 1)
, so there’s no need to divide or scale.ANSI SQL users
RAND()
function to generate a float between 0 and 1. However, SQL typically doesn’t generate a new random value for every row unless you call RAND()
inside a subquery or use it with a specific expression. In APL, rand()
behaves like a row-level function and produces a new value for each row automatically.Name | Type | Description |
---|---|---|
range | integer | Optional: A positive integer that specifies the upper exclusive limit of the range where you want to generate pseudo-random integers. The lower inclusive limit is 0. |
range
: A real number in the range between 0 (inclusive) and 1 (exclusive). Each call returns a pseudo-random float.
With range
: An integer in the range between 0 (inclusive) and range
(exclusive).
_time | random |
---|---|
2024-07-10T14:32:00Z | 0.6324890121902683 |