You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2020/03/30 15:18:00 UTC
[jira] [Commented] (IMPALA-6168) Different result range of
rand/random built-in function
[ https://issues.apache.org/jira/browse/IMPALA-6168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17071060#comment-17071060 ]
Gabor Kaszab commented on IMPALA-6168:
--------------------------------------
[~tadam] Could you link the doc jira here that covers the interval fix?
> Different result range of rand/random built-in function
> -------------------------------------------------------
>
> Key: IMPALA-6168
> URL: https://issues.apache.org/jira/browse/IMPALA-6168
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.10.0
> Reporter: Jin Chul Kim
> Assignee: Adam Tamas
> Priority: Minor
> Labels: correctness, newbie
>
> I am not sure this is a bug because it might be intended behavior. Please close this if it is not a bug.
> When I was re-implementing rand at IMPALA-5754, I realized some DBMSes(e.g. Postgres, MySQL and Vertica) adopt the following range: "0 <= result < 1". By the way, Impala's range of the current implementation is "0 <= result <= 1" and document also says "Returns a random value between 0 and 1".
> Would you let me know why the difference comes from? Please explain if it is intended behavior.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org