Input Table
The input is a sample of the iris dataset, with 4 feature columns and a target (response) column 'species'.
| id | sepal_length | sepal_width | petal_length | petal_width | species | redist |
|---|---|---|---|---|---|---|
| 76 | 6.6 | 3.0 | 4.4 | 1.4 | 2 | 1 |
| 101 | 6.3 | 3.3 | 6.0 | 2.5 | 3 | 3 |
| 57 | 6.3 | 3.3 | 4.7 | 1.6 | 2 | 1 |
| 122 | 5.6 | 2.8 | 4.9 | 2.0 | 3 | 2 |
| 38 | 4.9 | 3.6 | 1.4 | 0.1 | 1 | 1 |
| 99 | 5.1 | 2.5 | 3.0 | 1.1 | 2 | 2 |
| 61 | 5.0 | 2.0 | 3.5 | 1.0 | 2 | 1 |
| 78 | 6.7 | 3.0 | 5.0 | 1.7 | 2 | 3 |
| 93 | 5.8 | 2.6 | 4.0 | 1.2 | 2 | 3 |
| 17 | 5.4 | 3.9 | 1.3 | 0.4 | 1 | 2 |
SQL Function Call
SELECT * FROM TD_XGBoost (
ON iris_train_redist AS inputtable
USING
INPUTCOLUMNS ('[1:4]')
RESPONSECOLUMN ('species')
DataRedistributionColumn ('redist')
MODELTYPE ('Classification')
MAXDEPTH (1 )
NUMBOOSTEDTREES (32 )
ITERNUM (2 )
SEED (1 )
MinRowsPerAmp(10)
isDebug('true')
) as dt
Output
task_index tree_num iter class_num tree_order classification_tree
---------- -------- ---- --------- ---------- -------------------
0 1 1 0 0 {"id_":1,"sum_":-0.500000,"sumSq_":0.750000,"size_":3,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.850000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.666667,"scoreImprove_":0.666667,"leftNodeSize_":1,"rightNodeSize_":2},"leftChild_":{"id_":2,"sum_":0.500000,"sumSq_":0.250000,"size_":1,"maxDepth_":0,"value_":0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":0.100000},"rightChild_":{"id_":3,"sum_":-1.000000,"sumSq_":0.500000,"size_":2,"maxDepth_":0,"value_":-0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":-0.166667}}
6 1 1 0 0 {"id_":1,"sum_":-0.333333,"sumSq_":0.777778,"size_":4,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.250000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.750000,"scoreImprove_":0.750000,"leftNodeSize_":1,"rightNodeSize_":3},"leftChild_":{"id_":2,"sum_":0.666667,"sumSq_":0.444444,"size_":1,"maxDepth_":0,"value_":0.666667,"nodeType_":"REGRESSION_LEAF","prediction_":0.181818},"rightChild_":{"id_":3,"sum_":-1.000000,"sumSq_":0.333333,"size_":3,"maxDepth_":0,"value_":-0.333333,"nodeType_":"REGRESSION_LEAF","prediction_":-0.200000}}
7 1 1 0 0 {"id_":1,"sum_":-1.500000,"sumSq_":0.750000,"size_":3,"maxDepth_":0,"value_":-0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":-0.214286}
0 1 1 1 0 {"id_":1,"sum_":0.500000,"sumSq_":0.750000,"size_":3,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.850000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.666667,"scoreImprove_":0.666667,"leftNodeSize_":1,"rightNodeSize_":2},"leftChild_":{"id_":2,"sum_":-0.500000,"sumSq_":0.250000,"size_":1,"maxDepth_":0,"value_":-0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":-0.100000},"rightChild_":{"id_":3,"sum_":1.000000,"sumSq_":0.500000,"size_":2,"maxDepth_":0,"value_":0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":0.166667}}
6 1 1 1 0 {"id_":1,"sum_":-0.333333,"sumSq_":0.777778,"size_":4,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":6.200000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.250000,"scoreImprove_":0.250000,"leftNodeSize_":2,"rightNodeSize_":2},"leftChild_":{"id_":2,"sum_":0.333333,"sumSq_":0.555556,"size_":2,"maxDepth_":0,"value_":0.166667,"nodeType_":"REGRESSION_LEAF","prediction_":0.076923},"rightChild_":{"id_":3,"sum_":-0.666667,"sumSq_":0.222222,"size_":2,"maxDepth_":0,"value_":-0.333333,"nodeType_":"REGRESSION_LEAF","prediction_":-0.153846}}
7 1 1 1 0 {"id_":1,"sum_":0.500000,"sumSq_":0.750000,"size_":3,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.300000,"attr_":"petal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.666667,"scoreImprove_":0.666667,"leftNodeSize_":2,"rightNodeSize_":1},"leftChild_":{"id_":2,"sum_":1.000000,"sumSq_":0.500000,"size_":2,"maxDepth_":0,"value_":0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":0.166667},"rightChild_":{"id_":3,"sum_":-0.500000,"sumSq_":0.250000,"size_":1,"maxDepth_":0,"value_":-0.500000,"nodeType_":"REGRESSION_LEAF","prediction_":-0.100000}}
0 1 2 0 0 {"id_":1,"sum_":-0.384694,"sumSq_":0.551145,"size_":3,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.850000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.501815,"scoreImprove_":0.501815,"leftNodeSize_":1,"rightNodeSize_":2},"leftChild_":{"id_":2,"sum_":0.450166,"sumSq_":0.202649,"size_":1,"maxDepth_":0,"value_":0.450166,"nodeType_":"REGRESSION_LEAF","prediction_":0.090212},"rightChild_":{"id_":3,"sum_":-0.834860,"sumSq_":0.348495,"size_":2,"maxDepth_":0,"value_":-0.417430,"nodeType_":"REGRESSION_LEAF","prediction_":-0.140420}}
6 1 1 2 0 {"id_":1,"sum_":0.666667,"sumSq_":1.111111,"size_":4,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":6.200000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":1.000000,"scoreImprove_":1.000000,"leftNodeSize_":2,"rightNodeSize_":2},"leftChild_":{"id_":2,"sum_":-0.666667,"sumSq_":0.222222,"size_":2,"maxDepth_":0,"value_":-0.333333,"nodeType_":"REGRESSION_LEAF","prediction_":-0.153846},"rightChild_":{"id_":3,"sum_":1.333333,"sumSq_":0.888889,"size_":2,"maxDepth_":0,"value_":0.666667,"nodeType_":"REGRESSION_LEAF","prediction_":0.307692}}
7 1 2 0 0 {"id_":1,"sum_":-1.283254,"sumSq_":0.551779,"size_":3,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.300000,"attr_":"petal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.002866,"scoreImprove_":0.002866,"leftNodeSize_":2,"rightNodeSize_":1},"leftChild_":{"id_":2,"sum_":-0.811794,"sumSq_":0.329505,"size_":2,"maxDepth_":0,"value_":-0.405897,"nodeType_":"REGRESSION_LEAF","prediction_":-0.136916},"rightChild_":{"id_":3,"sum_":-0.471460,"sumSq_":0.222274,"size_":1,"maxDepth_":0,"value_":-0.471460,"nodeType_":"REGRESSION_LEAF","prediction_":-0.094353}}
0 1 2 1 0 {"id_":1,"sum_":0.384694,"sumSq_":0.551145,"size_":3,"maxDepth_":1,"nodeType_":"REGRESSION_NODE","split_":{"splitValue_":5.850000,"attr_":"sepal_length","type_":"REGRESSION_NUMERIC_SPLIT","score_":0.501815,"scoreImprove_":0.501815,"leftNodeSize_":1,"rightNodeSize_":2},"leftChild_":{"id_":2,"sum_":-0.450166,"sumSq_":0.202649,"size_":1,"maxDepth_":0,"value_":-0.450166,"nodeType_":"REGRESSION_LEAF","prediction_":-0.090212},"rightChild_":{"id_":3,"sum_":0.834860,"sumSq_":0.348495,"size_":2,"maxDepth_":0,"value_":0.417430,"nodeType_":"REGRESSION_LEAF","prediction_":0.140420}}