hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-1301) RAND() should be RAND_UNIF(); also, we should create RAND_NORM() and add options
Date Tue, 05 Apr 2011 22:05:05 GMT

     [ 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

Mime
View raw message