[
https://issues.apache.org/jira/browse/MADLIB-1231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16484601#comment-16484601
]
Frank McQuillan commented on MADLIB-1231:
-----------------------------------------
Moving out of 1.15.
This is a corner case and we don't need to explicitly trap it, at least not at
this point. If someone in the community feels otherwise, please let us know.
> Exception in correlation/covariance when mean of a column is null
> -----------------------------------------------------------------
>
> Key: MADLIB-1231
> URL: https://issues.apache.org/jira/browse/MADLIB-1231
> Project: Apache MADlib
> Issue Type: Bug
> Components: Module: Inferential Statistics
> Reporter: Nikhil
> Priority: Minor
>
> While working on https://issues.apache.org/jira/browse/MADLIB-1128, we found
> a bug in the correlation/covariance module.
> Repro steps:
> {code}
> create table foo(i int , j int);
> insert into foo values(1,NULL);
> madlib=# select madlib.correlation('foo','foo_out');
> 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)
> CONTEXT: Traceback (most recent call last):
> PL/Python function "correlation", line 23, in <module>
> return correlation.correlation(**globals())
> PL/Python function "correlation", line 71, in correlation
> PL/Python function "correlation", line 207, in _populate_output_table
> PL/Python function "correlation"
> madlib=#
> {code}
> This was introduced in https://issues.apache.org/jira/browse/MADLIB-1166 when
> we started supporting null values.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
