hive逗号分割行列转换

 select *

            from (

                select back_receipt_nos,order_no,reject_no

                from ods_oneplus.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;