select id, str_to_map(concat_ws(',',collect_set(concat(substr(repay_time,0,7), ':',round(interest,2)))),',',':') repay_interest from 50_repay t 转载于:https://www.cnblogs.com/0xcafedaddy/p/9474239.html