常见Metrics计算

AUC计算

pai -name=evaluate -project=algo_public
    -DoutputMetricTableName=output_metric_table
    -DoutputDetailTableName=output_detail_table
    -DinputTableName=input_data_table
    -DlabelColName=label
    -DscoreColName=score;

Group AUC计算

select group_name, (rank_pos - pos_cnt * (pos_cnt+1) / 2) / (pos_cnt * neg_cnt) as gauc
from (
    select group_name,
            sum(if(label=1, rn, 0)) as rank_pos,
            sum(if(label=1, 1,0)) as pos_cnt,
            sum(if(label=0, 1, 0)) as neg_cnt
    from (
        select group_name, label, rank() over(partition by group_name order by probs asc) as rn
        from your_table
    )
    group by group_name
);