select *
from (
select back_receipt_nos,order_no,reject_no
from ods_one.ods_us_wms_reject_order_match_all_d
where order_no = '10150501385980001'
) t1
lateral view explode(split(t1.back_receipt_nos, ',')) t as back_receipt_no
where 1 = 1;
select *
from (
select back_receipt_nos,order_no,reject_no
from ods_one.ods_us_wms_reject_order_match_all_d
where order_no = '10150501385980001'
) t1
lateral view explode(split(t1.back_receipt_nos, ',')) t as back_receipt_no
where 1 = 1;