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

Gavin McDonald updated MADLIB-883:
----------------------------------
    Reporter: Martijn Visser  (was: Martin Visser)

> Error when running lmf_igd_run with a large matrix
> --------------------------------------------------
>
>                 Key: MADLIB-883
>                 URL: https://issues.apache.org/jira/browse/MADLIB-883
>             Project: Apache MADlib
>          Issue Type: Bug
>            Reporter: Martijn Visser
>            Assignee: Xixuan (Aaron) Feng
>            Priority: Major
>
> Error when running lmf_igd_run function with 35000 columns:
> test=# SELECT madlib1_7.lmf_igd_run( 'lmf_model',                             
>                                                                               
>                             'lmf_data',                                       
>                                                                               
>                              'row',                                           
>                                                                               
>                               'col',                                          
>                                                                               
>                                'val',                                         
>                                                                               
>                                 999,                                          
>                                                                               
>                                  35000,                                       
>                                                                               
>                                   3,                                          
>                                                                               
>                                    0.1,                                       
>                                                                               
>                                     2,                                        
>                                                                               
>                                      10,                                      
>                                                                               
>                                       1e-9                                    
>                                                                               
>                                      );
> NOTICE:  Matrix lmf_data to be factorized: 999 x 35000
> ERROR:  plpy.SPIError: smallint out of range (plpython.c:4648)
> CONTEXT:  Traceback (most recent call last):
>   PL/Python function "internal_compute_lmf_igd", line 22, in <module>
>     return lmf_igd.compute_lmf_igd(**globals())
>   PL/Python function "internal_compute_lmf_igd", line 63, in compute_lmf_igd
>   PL/Python function "internal_compute_lmf_igd", line 281, in update
>   PL/Python function "internal_compute_lmf_igd", line 182, in runSQL
> PL/Python function "internal_compute_lmf_igd"
> SQL statement "SELECT  madlib1_7.internal_compute_lmf_igd( 
> '_madlib_lmf_igd_args', '_madlib_lmf_igd_state', textin(regclassout( $1 )),  
> $2 ,  $3 ,  $4 )"
> PL/pgSQL function "lmf_igd_run" line 39 at assignment
> In lmf_igd.py smallint is used which is causing this limitation.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to