td_intern otto

submission.sql

INSERT OVERWRITE TABLE submission
SELECT
  t2.id as id,
  IF(t1.probabilities[0] is null, 0, t1.probabilities[0]) as Class_1,
  IF(t1.probabilities[1] is null, 0, t1.probabilities[1]) as Class_2,
  IF(t1.probabilities[2] is null, 0, t1.probabilities[2]) as Class_3,
  IF(t1.probabilities[3] is null, 0, t1.probabilities[3]) as Class_4,
  IF(t1.probabilities[4] is null, 0, t1.probabilities[4]) as Class_5,
  IF(t1.probabilities[5] is null, 0, t1.probabilities[5]) as Class_6,
  IF(t1.probabilities[6] is null, 0, t1.probabilities[6]) as Class_7,
  IF(t1.probabilities[7] is null, 0, t1.probabilities[7]) as Class_8,
  IF(t1.probabilities[8] is null, 0, t1.probabilities[8]) as Class_9
FROM prediction t1
LEFT OUTER JOIN testing t2 ON (t1.rowid=t2.rowid)
ORDER by
  id;