考点 length 和 replace 的用法 select length('10,A,B') -length(replace('10,A,B',",","")) # hive sql SELECT size(split('10,A,B', ',')) - 1 ;