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)