[
https://issues.apache.org/jira/browse/PHOENIX-1516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14247832#comment-14247832
]
Lars Hofhansl commented on PHOENIX-1516:
----------------------------------------
Three more observations:
# MySQL only allow constants as random seeds
# PER_ROW determinism doesn't do what I expected it to do: It will produce the
same value of rand() for each row retrieved in a statement
# generating a new rand() in evaluate means that each time you'd call
ResultSet.getDouble(...) you'd get a new value... Not how a user would expect
it.
So this turns out to be a bit tricky. Would need to do something like what
Sequences do I guess.
> Add RANDOM built-in function
> ----------------------------
>
> Key: PHOENIX-1516
> URL: https://issues.apache.org/jira/browse/PHOENIX-1516
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Assignee: Lars Hofhansl
> Attachments: 1516.txt
>
>
> I often find it useful to generate some rows with random data.
> Here's a simple RANDOM() function that we could use for that.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
