hive字符串操作切割，切割后转行

split

SELECt split("1,2,3",",")

结果

[1,2,3]

explode

SELECT explode(SPLIT( "1,2,3",","))

结果

###

LATERAL VIEW explode()

SELECT t1.id ,t.valueFROM ( SELECT 1 AS id ,"1,2,3" AS DATA UNIOn ALL SELECT 2 AS id ,"1,2,3" AS DATA UNIOn ALL SELECT 3 AS id ,"1,2,3" AS DATA ) t1LATERAL VIEW explode(SPLIT(data,",")) t AS valueWHERe t1.id = '1';

结果

id value111213