prediction.sql

INSERT OVERWRITE TABLE prediction
SELECT 
  id,
  EXP(predicted)-1 as predicted
FROM(
  SELECT
     id,
     avg(predicted) AS predicted
  FROM(
    SELECT
      t.id,
      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
    id
) t2;