db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "DM.sbs.gmail" <david.myers.scibearsp...@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 Sun, 23 Aug 2015 15:59:35 GMT
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
>] 
>
>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.
Mime
View raw message