db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: [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:19 GMT
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

On 8/23/15 8:59 AM, DM.sbs.gmail wrote:
> Personally I would have thought a way to hook into R for stats 
> analysis would be more effective, and then there is no need to test as 
> the R devs will have tested thier code upstream.
>
> I have a feeling that there may already be a Java R library....
>
> Anyway just my thoughts
>
> David.
>
>
> On 23 August 2015 16:10:46 CEST, "Rick Hillegas (JIRA)" 
> <jira@apache.org> wrote:
>
>          [https://issues.apache.org/jira/browse/DERBY-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708383#comment-14708383
 <https://issues.apache.org/jira/browse/DERBY-5466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708383#comment-14708383>
 ]
>
>     Rick Hillegas commented on DERBY-5466:
>     ------------------------------------------------------------------------
>
>
>     Hi Scott,
>
>     Let me know if you think you won't have the bandwidth to add tests this week. We're
getting close to building the next feature release of Derby.
>
>     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 <http://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)
>
>
> -- 
> Sent from my Android device with K-9 Mail. Please excuse my brevity.


Mime
View raw message