[求助] 怎么把一个map<string,string>数据转成map<string,int>

Question

select 
userid,str_to_map(concat_ws(',',collect_list(concat(key,":",value)))) as tags 
from (
select 1 as userid,'时长' as key,12 as value
union ALL
select 1 as userid,'次数' as key,13 as value 
)t
group by userid

用上面的sql只能得到一个  {"时长":"12","次数":"13"} 的  map<string,string> 类型， 怎么可以转成 map<string,int>  
我想要的结果是  {"时长":12,"次数":13}

Answer 1

使用 convert() 函数，比如 '1' -> 1 就是 convert(int,'1')