DecisionForestEvaluator Example 1 - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Input

SQL Call

SELECT task_index, tree_num, variable_col, level_col, cnt
  FROM DecisionForestEvaluator (
    ON rft_model
  ) AS dt ORDER BY 1;

Output

Two worker nodes construct 25 trees each. The function outputs the level and count of variables for each tree and worker at each node.

task_index tree_num variable_col level_col cnt
0 0 price 0 1
0 0 fullbase 1 1
0 0 airco 1 1
0 0 lotsize 2 1
0 0 driveway 2 1
0 0 recroom 2 1
0 0 price 2 1
0 0 stories 3 4
0 0 garagepl 3 1
0 0 bathrms 3 1
0 0 bedrooms 4 1
0 0 lotsize 4 2
0 0 price 4 4
0 0 bedrooms    
0 0 lotsize    
0 0 driveway    
0 0 stories    
0 0 recroom    
0 0 price    
0 0 garagepl    
0 0 bathrms    
0 0 fullbase    
0 0 airco    
0 1 lotsize 0 1
0 1 recroom 1 1
0 1 bathrms 1 1
0 1 bedrooms 2 1
0 1 driveway 2 1
0 1 price 2 1
0 1 fullbase 2 1
0 1 bedrooms 3 1
0 1 driveway 3 1
0 1 price 3 1
0 1 garagepl 3 1
0 1 airco 3 1
0 1 bedrooms 4 1
0 1 price 4 3
0 1 bathrms 4 1
0 1 bedrooms    
0 1 lotsize    
0 1 driveway    
0 1 recroom    
0 1 price    
0 1 garagepl    
0 1 bathrms    
0 1 fullbase    
0 1 airco    
... .... .... ... ...