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)
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)