Generate Random Ints with RANDOMINT

[JimKnicely]

Hi,

It’s very easy to generate random integers in Vertica using the RANDOMINT function!

This RANDOMINT function returns a uniformly-distributed integer I, where 0 <= I < N, where N <= MAX_INT8. That is, RANDOMINT(N) returns one of the N integers from 0 through N-1.

The general syntax of the function is:

• RANDOMINT (N)

Example:

To generate several random integers between 0 and 5, inclusive, we could run a query like this one:

Code: Select all

dbadmin=> SELECT RANDOMINT(6) random_1,
dbadmin->        RANDOMINT(6) random_2,
dbadmin->        RANDOMINT(6) random_3,
dbadmin->        RANDOMINT(6) random_4;
random_1  | random_2 | random_3 | random_4
----------+----------+----------+----------
        5 |        1 |        0 |        4
(1 row)

Have fun!

[piglet]

Hmm.

Why did Vertica choose that the value we send into the RANDOMINT function parameter not be included as one of the available return values? I would hope that RANDINT(10) could return a random int between 0 and 10 and not 0 and < 10.