madlib-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From George Lin <jiaxin...@live.com>
Subject why the results are always different with the same SQL execution of the same SVM linear classification ...?
Date Wed, 28 Sep 2016 08:07:34 GMT
Dear sir,


It is strange that , why the results are always different with the same SQL execution of the
same SVM linear classification model and the same datasource as in the official URL of http://madlib.apache.org/docs/latest/group__grp__svm.html
 ?


the SQL is :

DROP TABLE IF EXISTS houses_svm, houses_svm_summary;
SELECT madlib.svm_classification('houses',
                                 'houses_svm',
                                 'price < 100000',
                                 'ARRAY[1, tax, bath, size]'
                           );
SELECT * FROM houses_svm;

The SQL's first time running result is :
{0.100414417254,-0.0184708830669,0.0251331467072,0.0154637720387}    35.9262602977    2427.20058061271
   100    15    0    {f,t}

But the SQL's 2nd time running result is :
{0.129850669599,-0.00779450119676,0.0767045650808,0.00732510805457}    18.4553559161    1300.96167857298
   100    15    0    {f,t}

everytime's result of executing this SQL is different, why?






Thank you!

Sincerely!
Georgelin(Lin JiaXin)
0086 180 500 42436(better signal)

Mime
View raw message