[jira] [Resolved] (DRILL-202) Implement average and standard deviation functions

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau resolved DRILL-202.
----------------------------------

    Resolution: Fixed

> Implement average and standard deviation functions
> --------------------------------------------------
>
>                 Key: DRILL-202
>                 URL: https://issues.apache.org/jira/browse/DRILL-202
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.0.0-rc1, 1.0.0-rc2
>            Reporter: Ted Dunning
>              Labels: newbie
>         Attachments: DRILL-202.patch
>
>
> I need several statistical functions including average.  To be complete, I would like to implement several of the statistical functions from Postgres:
> {code}
> Function	Argument Type	Return Type	Description
> avg(expression)	smallint, int, bigint, real, double precision, numeric, or interval	numeric for any integer-type argument, double precision for a floating-point argument, otherwise the same as the argument data type	the average (arithmetic mean) of all input values
> max(expression)	any array, numeric, string, or date/time type	same as argument type	maximum value of expression across all input values
> min(expression)	any array, numeric, string, or date/time type	same as argument type	minimum value of expression across all input values
> stddev(expression)	smallint, int, bigint, real, double precision, or numeric	double precision for floating-point arguments, otherwise numeric	historical alias for stddev_samp
> stddev_pop(expression)	smallint, int, bigint, real, double precision, or numeric	double precision for floating-point arguments, otherwise numeric	population standard deviation of the input values
> stddev_samp(expression)	smallint, int, bigint, real, double precision, or numeric	double precision for floating-point arguments, otherwise numeric	sample standard deviation of the input values
> variance(expression)	smallint, int, bigint, real, double precision, or numeric	double precision for floating-point arguments, otherwise numeric	historical alias for var_samp
> var_pop(expression)	smallint, int, bigint, real, double precision, or numeric	double precision for floating-point arguments, otherwise numeric	population variance of the input values (square of the population standard deviation)
> var_samp(expression)	smallint, int, bigint, real, double precision, or numeric	double precision for floating-point arguments, otherwise numeric	sample variance of the input values (square of the sample standard deviation)
> {code}
> I plan to put these in with sum.



--
This message was sent by Atlassian JIRA
(v6.2#6252)