hive 字符串数字 排序 注意事项 需要转类型 cast(alt_number AS BIGINT) 否则会导致排序错误 导致最大值为9

row_number() over(partition by display_code,alt_station,dt order by cast(alt_number AS BIGINT) DESC) rn