[
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
