Aaron Xixuan Feng created MADLIB-953:
----------------------------------------

             Summary: Two Install-Check Errors
                 Key: MADLIB-953
                 URL: https://issues.apache.org/jira/browse/MADLIB-953
             Project: Apache MADlib
          Issue Type: Test
            Reporter: Aaron Xixuan Feng


Tested on master branch on GitHub.

1. SVM: hard-coded schema "madlib"
{code}
SELECT madlib.svm_regression(
        'abalone_train_small',
        'svr_mdl',
        'rings',
        'ARRAY[1,diameter,shell,shucked,length]',
        NULL,NULL,'sex',
        'max_iter=50, init_stepsize=1, decay_factor=0.9, tolerance=1e-16, 
epsilon = 50, eps_table=abalone_eps',
        false);
psql:/tmp/madlib.3dspza/svm/test/linear_svm.sql_in.tmp:571: ERROR:  permission 
denied for schema madlib
{code}
I tested on a different schema name

2. Path: require m/d/y "datestyle" setting for insert, and hard-coded schema 
"madlib"
{code}
...
('04/16/2012 23:51:00', 101881, 2, 4, 'Male', 'West', 5, 0, 0, 0, 0),
('04/16/2012 23:55:00', 101331, 2, 4, 'Female', 'East', 5, 0, 0, 0, 0),
('04/16/2012 23:56:00', 101331, 2, 4, 'Female', 'East', 5, 1, 0, 0, 0),
('04/16/2012 23:57:00', 101331, 2, 4, 'Female', 'East', 5, 1, 1, 456, 77);
psql:/tmp/madlib.3dspza/utilities/test/path.sql_in.tmp:56: ERROR:  date/time 
field value out of range: "04/14/2012 23:43:00"
LINE 2: ('04/14/2012 23:43:00', 102201, 3, 3, 'Female', 'East', 3, 1...
         ^
HINT:  Perhaps you need a different "datestyle" setting.
{code}
The computer I am in is not using m/d/y date style, and it does not insert.
Perhaps to add in the beginning of the tests:
{code}SET DATESTYLE TO 'iso,mdy';{code}


Good luck for the release!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to