Hive开窗函数:
ROW_NUMBER() OVER (PARTITION BY sex, name ORDER BY business_dt desc) AS rnk_code
mysql实现:
set @rank=0,@c=null,@d=null;
select
sex, name,
@rank := if(@c = sex and @d = name, @rank+1,1) rnk_code,
@c := sex,
@d := name
from into_destination_table
order by sex, name, business_dt desc