FWBMVBUJPO
SELECT
mae(t3.predicted, t3.actual) as mae,
rmse(t3.predicted, t3.actual) as rmse
FROM
(
SELECT
t2.actual,
mf_predict(if(size(t2.Pu)=0, null, t2.Pu), if(size(p2.Qi)=0, null, Qi), t2.Bu, p2.Bi, t2.mu)
as predicted
FROM (
SELECT
t1.account_id,
t1.creator_id,
t1.rating as actual,
p1.Pu,
p1.Bu,
p1.mu
FROM
testing t1
LEFT OUTER JOIN sgd_model p1
ON (t1.account_id = p1.idx)
WHERE
p1.Bu IS NOT NULL AND p1.mu IS NOT NULL
) t2
LEFT OUTER JOIN sgd_model p2
ON (t2.creator_id = p2.idx)
) t3;
ֶशࡁΈϞσϧΛͬͯςετσʔλʹର͢Δ
."&
3.4&ΛٻΊΔʢখ͍͞΄ͲΑ͍ʣ