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;