Input
- Input table: rft_model, output by any of the DecisionForest Examples
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 | ||
... | .... | .... | ... | ... |