hive 列切割 split（column,regex）

2019独角兽企业重金招聘Python工程师标准>>>

SELECT split('12321|2321|23213|21321','\\|')

结果：  ["12321","2321","23213","21321"]

column1 为待分割字段

select id,column,column1 from table lateral view explode(split(column, '\\|')) myTable as column1;

example:

id	user	name	all_citys
1	user1	name1	beijing,tianjing
2	user2	name1	shanghai,chengdu

select id ,user,name,city from myTable LATERAL VIEW explode(split(all_citys,',')) adTable AS city

查询结果：

id	user	name	city
1	user1	name1	beijing
1	user1	name1	tianjing
2	user2	name2	shanghai
2	user2	name2	chengdu

 

转载于:https://my.oschina.net/leemoor/blog/798926