explode用法
select explode(split("010029,010030,1000001,财富_顶部轮播,财富banner,财富货币资金产品,财富快捷,财富-稳健组合楼层,我的-浮层广告",",")) etid;
因为视图吗,存的只是查询语句,并不保存结果集,所以在这里我推荐上面一种使用方法,使用explode
lateral view用法
create table tmp.yzy_la as
select "010029,010030,1000001,财富_顶部轮播,财富banner,财富货币资金产品,财富快捷,财富-稳健组合楼层,财富-稳健组合楼层头条,我的-浮层广告" etid;
select * from tmp.yzy_la
lateral view explode(split(etid,","))a as etid;