[jira] [Updated] (MADLIB-1231) Exception in correlation/covariance when mean of a column is null

["Frank McQuillan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/MADLIB-1231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Frank McQuillan updated MADLIB-1231:
------------------------------------
    Fix Version/s:     (was: v1.15)

> 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)