7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Forest_Drive Example 3 Output Summary Table
message

Computing 50 regression trees.

Each worker is computing 50 trees.

Each tree will contain approximately 506 points.

Poisson sampling parameter: 1.00

Mean of squared residuals: 14.24260343580995

% Var explained: 83.12878664102084

Query finished in 5.201 seconds.

Decision forest created in table "rft_model".

The following query returns the output shown in the following table:

SELECT task_index, tree_num, cast (tree AS character varying)
  FROM rft_model ORDER BY 1;
Forest_Drive Example 3 Output Table rtf_model
task_index tree_num cast (tree as character varying)
0 0 {"sum_":10723.700000000017,"sumSq_":283628.49,"size_":476,"id_":1,"maxDepth_":6,"split_":

{"splitValue_":9.629999999999999,"attr_":"lstat","score_":19754.296371441025,"type_":"REGRESSION_NUMERIC_SPLIT"

0 2 {"sum_":11020.200000000019,"sumSq_":282336.0800000003,"size_":490,"id_":1,"maxDepth_":6,"split_":

{"splitValue_":8.105,"attr_":"lstat","score_":16285.334028144687,"type_":"REGRESSION_NUMERIC_SPLIT"

0 3 {"sum_":11577.600000000006,"sumSq_":302737.4599999998,"size_":518,"id_":1,"maxDepth_":6,"split_":

{"splitValue_":9.725000000000001,"attr_":"lstat","score_":20801.712206059594,"type_":"REGRESSION_NUMERIC_SPLIT"

0 1 {"sum_":11877.69999999999,"sumSq_":309107.12999999995,"size_":535,"id_":1,"maxDepth_":6,"split_":

{"splitValue_":9.615,"attr_":"lstat","score_":19959.676845513393,"type_":"REGRESSION_NUMERIC_SPLIT"