td_intern rossmann

make_model.sql

INSERT
  OVERWRITE TABLE
    model SELECT 
      train_randomforest_regr(features, label, '-trees 20')
    FROM
      training3
    UNION ALL
    SELECT 
      train_randomforest_regr(features, label, '-trees 20')
    FROM
      training3
    UNION ALL
    SELECT 
      train_randomforest_regr(features, label, '-trees 20')
    FROM
      training3
    UNION ALL
    SELECT 
      train_randomforest_regr(features, label, '-trees 20')
    FROM
      training3
    UNION ALL
    SELECT 
      train_randomforest_regr(features, label, '-trees 20')
    FROM
      training3;