TD_DecisionForest Examples | DecisionForest | Teradata Vantage - TD_DecisionForest Examples - Analytics Database

Example: TD_DecisionForest Classification

TD_DecisionForest Call for Classification

CREATE VOLATILE TABLE DecisionForestOutput AS (
SELECT * FROM TD_DecisionForest(
  ON DT_Input AS PARTITION BY ANY
USING
  ResponseColumn('encoded')
  InputColumns(‘[2:12]’)
  TreeType('CLASSIFICATION')
  ) AS dt
 ) WITH DATA
ON COMMIT PRESERVE ROWS;

TD_DecisionForest Output for Classification

SELECT * FROM DecisionForestOutput

Example: TD_DecisionForest Regression

TD_DecisionForest SQL Call for Regression

SELECT * FROM TD_DecisionForest (
ON housing_sample AS inputtable PARTITION BY ANY
USING
  ResponseColumn('medv')
  InputColumns('[0:12]')
  MaxDepth(12)
  MinNodeSize(1)
  NumTrees(4)
  ModelType('REGRESSION')
  Seed(1)
  Mtry(3)
  MtrySeed(1)
) AS dt;

TD_DecisionForest Output for Regression