You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Jinchul Kim (JIRA)" <ji...@apache.org> on 2017/11/07 09:06:00 UTC
[jira] [Created] (IMPALA-6168) Different result range of
rand/random built-in function
Jinchul Kim created IMPALA-6168:
-----------------------------------
Summary: 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, Docs
Affects Versions: Impala 2.10.0
Reporter: Jinchul Kim
Priority: Minor
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
(v6.4.14#64029)