[
https://issues.apache.org/jira/browse/MADLIB-1128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16460035#comment-16460035
]
Nikhil commented on MADLIB-1128:
--------------------------------
While working on this story, we found a bug in the correlation/covariance
module. If the mean of a column is null , it throws an exception
{code}
ERROR: plpy.SPIError: Function "madlib.correlation_transition(double
precision[],double precision[],double precision[])": Correlation: Mean vector
contains NULL. (UDF_impl.hpp:210) (entry db 127.0.0.1:15432 pid=46000)
{code}
We will not fix this bug as part of this story but a new JIRA has been created
https://issues.apache.org/jira/browse/MADLIB-1231
> Add GROUP BY to correlation functions
> -------------------------------------
>
> Key: MADLIB-1128
> URL: https://issues.apache.org/jira/browse/MADLIB-1128
> Project: Apache MADlib
> Issue Type: Improvement
> Components: Module: Descriptive Statistics
> Reporter: Frank McQuillan
> Assignee: Nandish Jayaram
> Priority: Minor
> Fix For: v1.15
>
>
> http://madlib.incubator.apache.org/docs/latest/group__grp__correlation.html
> add:
> grouping_cols (optional)
> TEXT, default: null. A comma-separated list of columns on which to group
> results. If NULL, correlations/covariance is produced on the complete table.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
