1.0 - 8.00 - AdaBoost Example 2: OutputResponseProbDist - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

  • AttributeTable: iris_attribute_train
  • ResponseTable: iris_response_train

The preceding tables are created in DecisionTree Example 1.

SQL Call

SELECT * FROM AdaBoost (
 ON iris_attribute_train AS AttributeTable 
 ON iris_response_train AS ResponseTable 
 OUT TABLE OutputTable (iris_attribute_output)
 USING
 IDColumns ('pid')
 AttributeNameColumns ('attribute')
 AttributeValueColumn ('attrvalue')
 ResponseColumn ('response')
 ApproxSplits ('false')
 IterNum (5)
 NumSplits (10)
 MaxDepth (3)
 MinNodeSize (5)
 OutputResponseProbDist ('true')
) AS dt;

Output

 classifier_id | classifier_weight | node_id | node_label |   node_majorfreqs   |   attribute    |   split_value    | left_bucket | right_bucket | left_label | right_label |   left_majorfreqs    |   right_majorfreqs   |   left_label_probdist   |  right_label_probdist   | prob_label_order 
---------------+-------------------+---------+------------+---------------------+----------------+------------------+-------------+--------------+------------+-------------+----------------------+----------------------+-------------------------+-------------------------+------------------
             1 |  4.77068462446566 |       0 | 1          |   0.333333333333334 | petal_width    | 1.79999995231628 |             |              | 1          | 3           |    0.333333333333334 |    0.316666666666667 | 0.01667,0.32500,0.33333 | 0.31667,0.00833,0.00000 | 3,2,1
             1 |  4.77068462446566 |       2 | 3          |   0.316666666666667 | petal_length   |                5 |             |              | 3          | 3           |   0.0416666666666667 |                0.275 | 0.04167,0.00833,0.00000 | 0.27500,0.00000,0.00000 | 3,2,1
             1 |  4.77068462446566 |       1 | 1          |   0.333333333333334 | petal_length   | 1.70000004768372 |             |              | 1          | 2           |                  0.3 |                0.325 | 0.00000,0.00000,0.30000 | 0.01667,0.32500,0.03333 | 3,2,1
             1 |  4.77068462446566 |       5 | 3          |  0.0416666666666667 | sepal_width    | 3.09999990463257 |             |              | 3          | 2           |   0.0416666666666667 |  0.00833333333333333 | 0.04167,0.00000,0.00000 | 0.00000,0.00833,0.00000 | 3,2,1
             1 |  4.77068462446566 |       4 | 2          |               0.325 | sepal_width    | 3.40000009536743 |             |              | 2          | 1           |    0.316666666666667 |                0.025 | 0.01667,0.31667,0.00833 | 0.00000,0.00833,0.02500 | 3,2,1
             2 |  5.16478597392332 |       0 | 3          |   0.774011299435027 | petal_width    |              1.5 |             |              | 1          | 3           |    0.112994350282486 |    0.774011299435027 | 0.00000,0.07627,0.11299 | 0.77401,0.03672,0.00000 | 3,2,1
             2 |  5.16478597392332 |       1 | 1          |   0.112994350282486 | petal_length   | 1.70000004768372 |             |              | 1          | 2           |    0.101694915254237 |    0.076271186440678 | 0.00000,0.00000,0.10169 | 0.00000,0.07627,0.01130 | 3,2,1
             2 |  5.16478597392332 |       2 | 3          |   0.774011299435027 | sepal_width    |                3 |             |              | 3          | 3           |    0.711864406779659 |   0.0621468926553682 | 0.71186,0.01130,0.00000 | 0.06215,0.02542,0.00000 | 3,2,1
             2 |  5.16478597392332 |       5 | 3          |   0.711864406779659 | sepal_width    |              2.5 |             |              | 2          | 3           |  0.00282485875706215 |    0.711864406779659 | 0.00000,0.00282,0.00000 | 0.71186,0.00847,0.00000 | 3,2,1
             2 |  5.16478597392332 |       6 | 3          |  0.0621468926553673 | petal_width    | 1.79999995231628 |             |              | 2          | 3           |   0.0225988700564972 |   0.0621468926553673 | 0.00000,0.02260,0.00000 | 0.06215,0.00282,0.00000 | 3,2,1
             2 |  5.16478597392332 |       4 | 2          |   0.076271186440678 | sepal_width    | 3.20000004768372 |             |              | 2          | 1           |   0.0734463276836159 |   0.0112994350282486 | 0.00000,0.07345,0.00000 | 0.00000,0.00282,0.01130 | 3,2,1
             3 |  4.80015630561553 |       0 | 2          |   0.700952380952256 | sepal_length   |                5 |             |              | 3          | 2           |    0.112380952380952 |    0.699999999999875 | 0.11238,0.00095,0.01524 | 0.14857,0.70000,0.02286 | 3,2,1
             3 |  4.80015630561553 |       2 | 2          |   0.699999999999875 | petal_length   |                5 |             |              | 2          | 2           |    0.532380952380859 |    0.167619047619016 | 0.00476,0.53238,0.02286 | 0.14381,0.16762,0.00000 | 3,2,1
             3 |  4.80015630561553 |       1 | 3          |   0.112380952380952 | petal_length   |                4 |             |              | 1          | 3           |   0.0152380952380953 |    0.112380952380952 | 0.00000,0.00095,0.01524 | 0.11238,0.00000,0.00000 | 3,2,1
             3 |  4.80015630561553 |       3 | 1          |  0.0152380952380953 | petal_length   | 1.70000004768372 |             |              | 1          | 2           |   0.0152380952380953 | 0.000952380952380955 | 0.00000,0.00000,0.01524 | 0.00000,0.00095,0.00000 | 3,2,1
             3 |  4.80015630561553 |       6 | 2          |   0.167619047619016 | sepal_length   | 6.09999990463257 |             |              | 2          | 3           |    0.166666666666635 |    0.140952380952381 | 0.00286,0.16667,0.00000 | 0.14095,0.00095,0.00000 | 3,2,1
             3 |  4.80015630561553 |       5 | 2          |   0.532380952380859 | sepal_width    | 3.40000009536743 |             |              | 2          | 1           |    0.531428571428478 |                 0.02 | 0.00476,0.53143,0.00286 | 0.00000,0.00095,0.02000 | 3,2,1
             4 |  2.93378546925552 |       0 | 3          |   0.399559630238848 | petal_length   |                4 |             |              | 1          | 3           |    0.324051401778044 |    0.399559630238848 | 0.00000,0.00226,0.32405 | 0.39956,0.27413,0.00000 | 3,2,1
             4 |  2.93378546925552 |       1 | 1          |   0.324051401778044 | sepal_width    | 2.79999995231628 |             |              | 2          | 1           |  0.00225879315908387 |    0.323728717041032 | 0.00000,0.00226,0.00032 | 0.00000,0.00000,0.32373 | 3,2,1
             4 |  2.93378546925552 |       2 | 3          |   0.399559630238847 | petal_width    | 1.79999995231628 |             |              | 2          | 3           |    0.217660345841801 |     0.32340603230402 | 0.07615,0.21766,0.00000 | 0.32341,0.05647,0.00000 | 3,2,1
             4 |  2.93378546925552 |       3 | 2          | 0.00225879315908387 | petal_length   | 1.39999997615814 |             |              | 1          | 2           | 0.000322684737011981 |  0.00225879315908387 | 0.00000,0.00000,0.00032 | 0.00000,0.00226,0.00000 | 3,2,1
             4 |  2.93378546925552 |       6 | 3          |    0.32340603230402 | sepal_width    | 3.20000004768372 |             |              | 3          | 2           |      0.3201791849339 |    0.056469828977086 | 0.32018,0.00000,0.00000 | 0.00323,0.05647,0.00000 | 3,2,1
             4 |  2.93378546925552 |       5 | 2          |   0.217660345841801 | sepal_length   |                5 |             |              | 3          | 2           |   0.0380767989674136 |    0.217660345841801 | 0.03808,0.00000,0.00000 | 0.03808,0.21766,0.00000 | 3,2,1
             5 | 0.842037830628892 |       0 | 2          |   0.472604368947133 | sepal_width    | 3.20000004768372 |             |              | 3          | 2           |    0.396105784212362 |    0.391974901879705 | 0.39611,0.08063,0.01553 | 0.01178,0.39197,0.10398 | 3,2,1
             5 | 0.842037830628892 |       2 | 2          |   0.391974901879705 | petal_width    | 1.20000004768372 |             |              | 1          | 2           |    0.103975470945062 |    0.391974901879705 | 0.00000,0.00000,0.10398 | 0.01178,0.39197,0.00000 | 3,2,1
             5 | 0.842037830628892 |       1 | 3          |   0.396105784212362 | petal_length   | 4.69999980926514 |             |              | 2          | 3           |   0.0239200285613633 |    0.382063180380316 | 0.01404,0.02392,0.01553 | 0.38206,0.05671,0.00000 | 3,2,1
             5 | 0.842037830628892 |       3 | 2          |  0.0239200285613633 | sepal_length   | 5.40000009536743 |             |              | 1          | 2           |   0.0155336679476988 |   0.0234440080924803 | 0.01404,0.00048,0.01553 | 0.00000,0.02344,0.00000 | 3,2,1
             5 | 0.842037830628892 |       6 | 2          |   0.391974901879705 | petal_length   |                5 |             |              | 2          | 3           |    0.391974901879705 |   0.0117807079121293 | 0.00000,0.39197,0.00000 | 0.01178,0.00000,0.00000 | 3,2,1
             5 | 0.842037830628892 |       4 | 3          |   0.382063180380316 | sepal_width    | 2.79999995231628 |             |              | 3          | 3           |   0.0583265080397316 |    0.323736672340584 | 0.05833,0.04165,0.00000 | 0.32374,0.01506,0.00000 | 3,2,1
(29 rows)