hive中split结合explode的嵌套split子查询

写法一：用虚表实现
WITH tbl1 as(
select explode(split('G1,消费分期|G2,账单分期|G3,不分期','\\|')) as t1
),
tbl2 as (
select split(t1,',') as t2 FROM tbl1
)
select t2[0],t2[1] from tbl2;

 写法二：合并嵌套子查询

                    
select split(t1,',')[0],split(t1,',')[1] as t2
FROM (
select explode(split("G1,消费分期|G2,账单分期|G3,不分期",'\\|')) as t1)tmp;

特别注意hive中子查询的表需要加别名，否则容易报如下所示不能识别错误