AUC UDAF for BinaryClassificationMetrics

-- option 1
select
   auroc(label, prob) as auroc
from
   data;

-- option 2
WITH roc as (
  select
    roc(label, prob) as tpr, tpr
  from
    data
)
select
  auc(fpr, tpr) as auroc -- auc is UDAF, input is sorted by fp asc
from (  
  select 
    fpr, tpr
  from
    roc
  DISTRIBUTE BY 
    floor(fpr / 0.2) -- 5 bins
  SORT BY 
    fpr ASC
) t