td_intern rossmann

prediction.sql

INSERT OVERWRITE TABLE prediction
SELECT 
  rowid,
  EXP(predicted)-1 as predicted
FROM(
  SELECT
     rowid,
     avg(predicted) AS predicted
  FROM(
    SELECT
      t.rowid,
      tree_predict(p.model_id, p.model_type, p.pred_model, t.features, false) as predicted
    FROM
      model p
      LEFT OUTER JOIN testing3 t
  ) t1
  group by
    rowid
) t2;