Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Mon, 24 Aug 2015 19:58:46 +0000 (UTC)
From: "Rick Hillegas (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12527344.1318766387000.150322.1440446326545@Atlassian.JIRA>
In-Reply-To: <JIRA.12527344.1318766387000@Atlassian.JIRA>
References: <JIRA.12527344.1318766387000@Atlassian.JIRA>
 <JIRA.12527344.1318766387766@arcas>
Subject: [jira] [Commented] (DERBY-5466) Add support for SQL Standard
 statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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 
distros.

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

Thanks,
-Rick


> Add support for SQL Standard statistics functions, such as STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP
> -----------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5466
>                 URL: https://issues.apache.org/jira/browse/DERBY-5466
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.8.1.2
>            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, var_pop_formulas.txt
>
>
> Any of these RDBMS support the SQL standard statistics functions STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP:
> - DB2 (only STDDEV, VARIANE)
> - H2 
> - HSQLDB 
> - 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
(v6.3.4#6332)