0

The documentation for Amazon Redshift's RANDOM function does not indicate which pseudorandom number generator is used.

The documentation for Amazon Redshift's SET function indicates the ability to set a seed between 0 and 1, which is multiplied by 2^(31)-1.

While this helps verify the precision of values for the output (already known to be DOUBLE PRECISION by the RANDOM function documentation), I have been unable to locate anywhere in the documentation nor an online search precisely which pseudorandom number generator is being used.

Stephen DeSalvo
  • 717
  • 2
  • 7
  • 14
  • 2
    I can't speak for redshift specifically, but postgres (from which redshift was forked about 15 years ago) uses the system-provided random number generator. Since redshift is closed source, and runs on inaccessible systems, I strongly suspect that you need to talk to Amazon to get an accurate answer. – jmelesky May 20 '19 at 21:07
  • @jmelesky Thanks, it seems then that https://stackoverflow.com/questions/9816114/quality-of-postgresqls-random-function is probably the closest publicly available answer. – Stephen DeSalvo May 21 '19 at 13:20

0 Answers0