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.
For users of other query languages
If you come from other query languages, this section explains how to adjust your existing queries to achieve the same results in APL.Splunk SPL users
Splunk SPL users
In Splunk SPL, the
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
ANSI SQL users
ANSI SQL uses the
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.Usage
Syntax
Parameters
| 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. |
Returns
Withoutrange: 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).
Example
Query| _time | random |
|---|---|
| 2024-07-10T14:32:00Z | 0.6324890121902683 |