[
https://issues.apache.org/jira/browse/TAJO-921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14386184#comment-14386184
]
ASF GitHub Bot commented on TAJO-921:
-------------------------------------
Github user jihoonson commented on the pull request:
https://github.com/apache/tajo/pull/427#issuecomment-87540688
Hi @sirpkt, thanks for your patch.
I executed the same queries in newly added unit tests with pgsql, but got
different results.
Would you check it? Here are the results of pgsql.
* result of testStdDevPop1
```
linenumber_stddev_pop | suppkey_stddev_pop | extendedprice_stddev_pop |
discount_stddev_pop
------------------------+--------------------+--------------------------+---------------------
0 | 0 | 0 |
0
0.50000000000000000000 | 197.500000000000 | 12407.465 |
0.0250000022351742
0 | 0 | 0 |
0
0 | 0 | 0 |
0
0.50000000000000000000 | 2371.000000000000 | 3630.79000000004 |
0.0200000014156103
(5 rows)
```
* result of testStdDevSamp1
```
linenumber_stddev_samp | suppkey_stddev_samp | extendedprice_stddev_samp |
discount_stddev_samp
------------------------+---------------------+---------------------------+----------------------
| | |
0.70710678118654752440 | 279.307178568686 | 17546.8052776695 |
0.035355342220341
| | |
| | |
0.70710678118654752440 | 3353.100356386608 | 5134.71246012867 |
0.0282842732494372
(5 rows)
```
> Add STDDEV_SAMP and STDDEV_POP window functions
> -----------------------------------------------
>
> Key: TAJO-921
> URL: https://issues.apache.org/jira/browse/TAJO-921
> Project: Tajo
> Issue Type: Sub-task
> Components: function/udf, physical operator
> Reporter: Hyunsik Choi
> Assignee: Keuntae Park
> Fix For: 0.11.0
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
