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)"
<[email protected]> 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.
