hive 按照从大到小 top 百分之多少

计算按照从大到小 top 百分之多少的人

1，，以及按照降序排好位置，打上序号标签，找到max 那个rank 是多少
2，33316839 数值代替最大rank 那个数
CASE WHEN RANK_NUM <= 333168390.02 THEN ‘top2%’ – 筛选前20%的物品
WHEN RANK_NUM <= 333168390.05 AND RANK_NUM >333168390.02 THEN ‘2%-5%’
WHEN RANK_NUM <= 333168390.1 AND RANK_NUM >33316839 0.05 THEN ‘5%-10%’
WHEN RANK_NUM <= 333168390.15 AND RANK_NUM >33316839 0.1 THEN ‘10%-15%’
WHEN RANK_NUM <= 333168390.20 AND RANK_NUM >33316839 0.15 THEN ‘15%-20%’
WHEN RANK_NUM <= 333168390.30 AND RANK_NUM >33316839 0.20 THEN ‘20%-30%’
WHEN RANK_NUM <= 333168390.40 AND RANK_NUM >33316839 0.30 THEN ‘30%-40%’
WHEN RANK_NUM <= 333168390.50 AND RANK_NUM >33316839 *0.40 THEN ‘40%-50%’
ELSE ‘小于50%’ END AS RANK_Percent – 剩下的15%物品