hive计算几个月的最大最小时一定要把string类型转换成int类型

数据如下

错误写法！

select  msisdn            as  msisdn
,max(no_active_day)       as  60002_d_no_active_day_con_max_m6
,min(called_ops_nbr_con)  as  60002_d_called_ops_nbr_con_min_m6
from xyxj_test_1221_60002_val where stat_month>=202105 and stat_month<=202110
group by msisdn
;

正确写法！

select  msisdn            as  msisdn
,max(no_active_day)       as  60002_d_no_active_day_con_max_m6
,min(cast(called_ops_nbr_con as int))  as  60002_d_called_ops_nbr_con_min_m6
from xyxj_test_1221_60002_val where stat_month>=202105 and stat_month<=202110
group by msisdn
;