You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/12/22 06:40:58 UTC

[jira] [Created] (CALCITE-1552) Add RAND function, returning DOUBLE values in the range 0..1

Julian Hyde created CALCITE-1552:
------------------------------------

             Summary: Add RAND function, returning DOUBLE values in the range 0..1
                 Key: CALCITE-1552
                 URL: https://issues.apache.org/jira/browse/CALCITE-1552
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Add {{RAND}} function, returning {{DOUBLE}} values in the range 0..1. It has variants {{RAND()}} and {{RAND(seed)}}.

Also, add {{RAND_INTEGER(seed, bound)}}, support for a seed when generating random integers.

To support seeds, the random function needs to have state. The random number generator is initialized, using the seed, on first use, and subsequent calls use the same random number generator. So, we are building on CALCITE-1548.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)