td_intern otto

mlogloss.sql

-- 正しいラベルを挿入
INSERT OVERWRITE TABLE cv1
SELECT t1.*, t2.label as actual
FROM pred_cv t1 
LEFT OUTER JOIN test_cv t2 ON (t1.rowid=t2.rowid);

-- mlogloss を計算
SELECT 
  SUM(LN(IF(actual = 0,
        probabilities[0],
        IF(actual = 1,
          probabilities[1],
          IF(actual = 2,
            probabilities[2],
            IF(actual = 3,
              probabilities[3],
              IF(actual = 4,
                probabilities[4],
                IF(actual = 5,
                  probabilities[5],
                  IF(actual = 6,
                    probabilities[6],
                    IF(actual = 7,
                      probabilities[7],
                      IF(actual = 8,
                        probabilities[8],
                        0)))))))))))* (-1) / COUNT(1)
FROM
  cv1
;