阿里云人工智能平台PAIGBDT回归-云淘科技

组件配置

您可以使用以下任意一种方式，配置GBDT回归组件参数。

方式一：可视化方式

在Designer（原PAI-Studio）工作流页面配置组件参数。

方式二：PAI命令方式

使用PAI命令方式，配置该组件参数。您可以使用SQL脚本组件进行PAI命令调用，详情请参见SQL脚本。

PAI -name gbdt
    -project algo_public
    -DfeatureSplitValueMaxSize="500"
    -DlossType="0"
    -DrandSeed="0"
    -DnewtonStep="0"
    -Dshrinkage="0.05"
    -DmaxLeafCount="32"
    -DlabelColName="campaign"
    -DinputTableName="bank_data_partition"
    -DminLeafSampleCount="500"
    -DsampleRatio="0.6"
    -DgroupIDColName="age"
    -DmaxDepth="11"
    -DmodelName="xlab_m_GBDT_83602"
    -DmetricType="2"
    -DfeatureRatio="0.6"
    -DinputTablePartitions="pt=20150501"
    -Dtau="0.6"
    -Dp="1"
    -DtestRatio="0.0"
    -DfeatureColNames="previous,cons_conf_idx,euribor3m"
    -DtreeCount="500"

示例

1. 使用SQL语句，生成测试数据。

   drop table if exists gbdt_ls_test_input;
   create table gbdt_ls_test_input
   as
   select
       *
   from
   (
       select
           cast(1 as double) as f0,
           cast(0 as double) as f1,
           cast(0 as double) as f2,
           cast(0 as double) as f3,
           cast(0 as bigint) as label
       from dual
       union all
           select
               cast(0 as double) as f0,
               cast(1 as double) as f1,
               cast(0 as double) as f2,
               cast(0 as double) as f3,
               cast(0 as bigint) as label
       from dual
       union all
           select
               cast(0 as double) as f0,
               cast(0 as double) as f1,
               cast(1 as double) as f2,
               cast(0 as double) as f3,
               cast(1 as bigint) as label
       from dual
       union all
           select
               cast(0 as double) as f0,
               cast(0 as double) as f1,
               cast(0 as double) as f2,
               cast(1 as double) as f3,
               cast(1 as bigint) as label
       from dual
       union all
           select
               cast(1 as double) as f0,
               cast(0 as double) as f1,
               cast(0 as double) as f2,
               cast(0 as double) as f3,
               cast(0 as bigint) as label
       from dual
       union all
           select
               cast(0 as double) as f0,
               cast(1 as double) as f1,
               cast(0 as double) as f2,
               cast(0 as double) as f3,
               cast(0 as bigint) as label
       from dual
   ) a;

   生成的测试数据表gbdt_ls_test_input如下。

   f0	f1	f2	f3	label
   1.0	0.0	0.0	0.0	0
   0.0	0.0	1.0	0.0	1
   0.0	0.0	0.0	1.0	1
   0.0	1.0	0.0	0.0	0
   1.0	0.0	0.0	0.0	0
   0.0	1.0	0.0	0.0	0

2. 使用PAI命令，提交GBDT回归组件的训练参数。

   drop offlinemodel if exists gbdt_ls_test_model;
   PAI -name gbdt
       -project algo_public
       -DfeatureSplitValueMaxSize="500"
       -DlossType="3"
       -DrandSeed="0"
       -DnewtonStep="1"
       -Dshrinkage="0.5"
       -DmaxLeafCount="32"
       -DlabelColName="label"
       -DinputTableName="gbdt_ls_test_input"
       -DminLeafSampleCount="1"
       -DsampleRatio="1"
       -DmaxDepth="10"
       -DmetricType="0"
       -DmodelName="gbdt_ls_test_model"
       -DfeatureRatio="1"
       -Dp="1"
       -Dtau="0.6"
       -DtestRatio="0"
       -DfeatureColNames="f0,f1,f2,f3"
       -DtreeCount="10"

3. 使用PAI命令，提交预测组件参数。

   drop table if exists gbdt_ls_test_prediction_result;
   PAI -name prediction
       -project algo_public
       -DdetailColName="prediction_detail"
       -DmodelName="gbdt_ls_test_model"
       -DitemDelimiter=","
       -DresultColName="prediction_result"
       -Dlifecycle="28"
       -DoutputTableName="gbdt_ls_test_prediction_result"
       -DscoreColName="prediction_score"
       -DkvDelimiter=":"
       -DinputTableName="gbdt_ls_test_input"
       -DenableSparse="false"
       -DappendColNames="label"

4. 查看预测结果表gbdt_ls_test_prediction_result。

   label	prediction_result	prediction_score	prediction_detail
   0	NULL	0.0	{“label”: 0}
   0	NULL	0.0	{“label”: 0}
   1	NULL	0.9990234375	{“label”: 0.9990234375}
   1	NULL	0.9990234375	{“label”: 0.9990234375}
   0	NULL	0.0	{“label”: 0}
   0	NULL	0.0	{“label”: 0}