IT 数据清洗：足迹第六十五步：Hadoop时代，工具最底层依然是SQL函数

1

substr(sfzh, 0, 5)||‘地区’

2

substr(dz,POSITION(‘县’ IN a.sqxxdz )+1,3) as 乡镇

3

length(sfzh) =18 and cast(substr(sfzh, 17, 1) as integer) % 2 = 0

4

replace(sfzh,’ ‘,’’) as sfzh

5

SELECT
列1, string_agg(列2,’,’) AS 别名
FROM
表名
GROUP BY 列1 ;
结果