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

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

结果

[1,2,3]

explode

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

结果

1
2
3

SELECT  t1.id
        ,t.value
FROM    (
            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
        ) t1
LATERAL VIEW explode(SPLIT(data,",")) t AS value
WHERe   t1.id = '1'
;

结果

id value
1	1
1	2
1	3