[ 
https://issues.apache.org/jira/browse/BEAM-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16144567#comment-16144567
 ] 

ASF GitHub Bot commented on BEAM-2612:
--------------------------------------

GitHub user vectorijk reopened a pull request:

    https://github.com/apache/beam/pull/3568

    [BEAM-2612] Variance builtin aggregation functions

    implement var_pop, var_samp builtin aggregation functions


You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/vectorijk/beam beam-2612-variance

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/beam/pull/3568.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 #3568
    
----
commit 8fbb9006dd479b42a0798fe1c1eaf0e509649bc2
Author: Kai Jiang <jiang...@gmail.com>
Date:   2017-08-16T23:13:26Z

    var_pop and var_samp
    
    two builtin aggregation functions

commit 53612b5f9e256248212c5d743ea5410a8eeffd5f
Author: Kai Jiang <jiang...@gmail.com>
Date:   2017-08-17T00:26:04Z

    fix checkstyle

commit 1256f63b2686c0e7d1d0c2a5863945cff9c79fea
Author: Kai Jiang <jiang...@gmail.com>
Date:   2017-08-28T20:06:36Z

    address comments
    
    change type of sum in class VarAgg to BigDecimal
    move isSamp field to Var
    rename VarPop -> Var to make more generic
    move logic to prepareOutput() both for Avg and Var
    set MathContext to handle potential exception with BigDecimal divide.

commit 27b84cb4702e9d8960d1bfc5b59e48d8e5f446dd
Author: Kai Jiang <jiang...@gmail.com>
Date:   2017-08-28T20:13:38Z

    newlines

commit 7db3f490aeeb34f01b9064e274feacacbfa67092
Author: Kai Jiang <jiang...@gmail.com>
Date:   2017-08-28T20:18:09Z

    Merge branch 'DSL_SQL' into beam-2612-variance

commit fb0b05c163f6de2760c13af05abd9b41d9b57de9
Author: Kai Jiang <jiang...@gmail.com>
Date:   2017-08-28T23:36:47Z

    rebase issue

----


> support variance builtin aggregation function
> ---------------------------------------------
>
>                 Key: BEAM-2612
>                 URL: https://issues.apache.org/jira/browse/BEAM-2612
>             Project: Beam
>          Issue Type: New Feature
>          Components: dsl-sql
>            Reporter: Kai Jiang
>            Assignee: Kai Jiang
>
> two builtin aggregate functions
> VAR_POP
> the population variance (square of the population standard deviation)
> VAR_SAMP
> the sample variance (square of the sample standard deviation)
> https://calcite.apache.org/docs/reference.html#aggregate-functions



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to