You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Aaron Xixuan Feng (JIRA)" <ji...@apache.org> on 2016/01/11 02:01:50 UTC
[jira] [Updated] (MADLIB-953) Two Install-Check Errors
[ https://issues.apache.org/jira/browse/MADLIB-953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aaron Xixuan Feng updated MADLIB-953:
-------------------------------------
Description:
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 this in the beginning of the tests:
{code}SET DATESTYLE TO 'iso,mdy';{code}
Good luck for the new release!
was:
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!
> 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 this in the beginning of the tests:
> {code}SET DATESTYLE TO 'iso,mdy';{code}
> Good luck for the new release!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)