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 >] > >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 >> 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.
