[ https://issues.apache.org/jira/browse/SPARK-27930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16859628#comment-16859628 ]
Yuming Wang edited comment on SPARK-27930 at 6/10/19 12:54 PM: --------------------------------------------------------------- Workaround: {code:sql} select rand() {code} {code:sql} select reflect("java.lang.Math", "random") {code} was (Author: q79969786): Workaround: {code:sql} select reflect("java.lang.Math", "random") {code} > Add built-in Math Function: RANDOM > ---------------------------------- > > Key: SPARK-27930 > URL: https://issues.apache.org/jira/browse/SPARK-27930 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > The RANDOM function generates a random value between 0.0 and 1.0. Syntax: > {code:sql} > RANDOM() > {code} > More details: > https://www.postgresql.org/docs/12/functions-math.html > Other DBs: > https://docs.aws.amazon.com/redshift/latest/dg/r_RANDOM.html > https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Mathematical/RANDOM.htm?tocpath=SQL%20Reference%20Manual%7CSQL%20Functions%7CMathematical%20Functions%7C_____24 -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org