lateral view explode

select name,vk_get_yipro_proper(prop,'innerId') from inte_product_df 
where  name ='温州中央绿轴项目';

image.png

select name,data1 from inte_product_df 
lateral view explode(split(vk_get_yipro_proper(prop,'innerId'),'/')) tmp as data1
where  name ='温州中央绿轴项目';

image.png