You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/05/23 13:50:17 UTC
[jira] [Commented] (TAJO-1620) random() in an SQL should generate
RANDOM numbers
[ https://issues.apache.org/jira/browse/TAJO-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14557290#comment-14557290 ]
ASF GitHub Bot commented on TAJO-1620:
--------------------------------------
GitHub user eminency opened a pull request:
https://github.com/apache/tajo/pull/582
TAJO-1620: random() in an SQL should generate RANDOM numbers
One more exception case is added in ConstantFolding rule.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/eminency/tajo TAJO-1620
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/582.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #582
----
commit 1b9fbc3de114b4bc8721a2089546adc24328b78d
Author: Jongyoung Park <em...@gmail.com>
Date: 2015-05-23T11:46:19Z
Added exception case for random() in ConstantFolding
----
> random() in an SQL should generate RANDOM numbers
> -------------------------------------------------
>
> Key: TAJO-1620
> URL: https://issues.apache.org/jira/browse/TAJO-1620
> Project: Tajo
> Issue Type: Bug
> Components: function/udf
> Affects Versions: 0.10.0
> Reporter: Youngkyong Ko
> Assignee: Jongyoung Park
> Priority: Minor
> Attachments: TAJO-1620.patch
>
>
> random() function in projection list should generate different random numbers per each record. Currently it generates same numbers like below:
> SELECT o_custkey, o_totalprice, random(10) as rand from orders limit 10;
> o_custkey, o_totalprice, rand
> -------------------------------
> 36901, 173665.47, 8
> 78002, 46929.18, 8
> 123314, 193846.25, 8
> 136777, 32151.78, 8
> 44485, 144659.2, 8
> 55624, 58749.59, 8
> 39136, 252004.18, 8
> 130057, 208660.75, 8
> 66958, 163243.98, 8
> 61001, 58949.67, 8
> (10 rows, 1.195 sec, 178 B selected)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)