select
order_id,
comment_label_id2,
create_time,
score,
remark
FROM
(
select
score,
remark,
create_time,
order_id,
comment_label_id
from
bi_ods.t_scd_order_comment
where
create_time >= '2016-03-01'
AND create_time < '2016-03-02'
) as t lateral view explode(
split(comment_label_id, ',')
) e as comment_label_id2