db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5466) Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP
Date Mon, 24 Aug 2015 19:58:46 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14709956#comment-14709956

Rick Hillegas commented on DERBY-5466:

Thanks for that suggestion, David. R is licensed under the GPL, which is 
generally a deal-breaker for inclusion in an Apache project. I do 
understand that Apache Spark uses a lot of code which is written in R. I 
don't understand how Spark has worked around the license 
incompatibilities. Maybe the license is not a problem for Spark because 
Spark uses Maven.  With Maven, the build could download GPL-licensed 
machinery so that the Apache source distribution wouldn't have to bundle 
anything tainted by GPL. Derby, however, uses Ant. We have worked very 
hard to make sure that the Derby distribution bundles everything needed 
to build Derby. That is a pre-condition for being bundled in the Linux 

I would prefer not to wrestle with build, license, and bundling issues 
this late in the release cycle.


> Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP,
> -----------------------------------------------------------------------------------------------------
>                 Key: DERBY-5466
>                 URL: https://issues.apache.org/jira/browse/DERBY-5466
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions:
>            Reporter: Lukas Eder
>            Priority: Minor
>              Labels: derby_triage10_10
>         Attachments: DERBY-5466.stats.patch, derby-5466-01-aa-aggregatorClasses.diff,
derby-5466-02-aa-bindLogic.diff, derby-5466-02-ab-bindLogic.diff, derby-5466-03-aa-distinctError.diff,
> Any of these RDBMS support the SQL standard statistics functions STDDEV_POP, STDDEV_SAMP,
> - DB2 (only STDDEV, VARIANE)
> - H2 
> - Ingres 
> - MySQL 
> - Oracle 
> - Postgres 
> - SQL Server (named STDEVP, STDEV, VARP, VAR)
> - Sybase ASE
> - Sybase SQL Anywhere
> These don't:
> - Derby
> - SQLite
> This would be a useful addition for Derby, I think.
> An even larger example list of possible statistics aggregate functions is listed in the
Postgres documentation:
> http://www.postgresql.org/docs/9.0/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE

This message was sent by Atlassian JIRA

View raw message