[GitHub] [madlib] kaknikhil commented on pull request #523: Prevent an "integer out of range" exception in linear regression train

[GitBox <gi...@apache.org>]

kaknikhil commented on pull request #523:
URL: https://github.com/apache/madlib/pull/523#issuecomment-758288163


   We successfully ran a test with 5 billion rows.  
   
   ```
   DROP TABLE IF EXISTS tab1;
   CREATE TABLE tab1(
        indep_var BIGINT,
        dep_var BIGINT
   );
   INSERT INTO tab1 VALUES(generate_series(1,5000000000), generate_series(1,5000000000));
   
   DROP TABLE IF EXISTS test_linregr, test_linregr_summary;
   SELECT madlib.linregr_train( 'tab1',
                                'test_linregr',
                                'dep_var',
                                'ARRAY[1, indep_var]'
                              );
    linregr_train
   ---------------
   
   (1 row)
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org