[ https://issues.apache.org/jira/browse/HIVE-1301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1301: --------------------------------- Component/s: UDF > RAND() should be RAND_UNIF(); also, we should create RAND_NORM() and add > options > -------------------------------------------------------------------------------- > > Key: HIVE-1301 > URL: https://issues.apache.org/jira/browse/HIVE-1301 > Project: Hive > Issue Type: Wish > Components: UDF > Reporter: Adam Kramer > Assignee: Paul Yang > > The generation of pseudorandom data is very useful, but would be even MORE > useful if we had a few levers to pull. > Currently, RAND() generates a random number pulled from a uniform > distribution between 0 and 1. It would be great if we could user-specify the > min and max because that is a more elegant way to write code: RAND()*200+50 > will generate the same thing as RAND_UNIF(min=50,max=250) but the latter is a > much better way to express this in a readable manner. > Similarly, it would be useful to have non-uniform random data for statistical > purposes. RAND_NORM(mean=0,sd=1) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira