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_m6from xyxj_test_1221_60002_val where stat_month>=05 and stat_month<=10group 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_m6from xyxj_test_1221_60002_val where stat_month>=05 and stat_month<=10group by msisdn;