Closed
Description
Hi there
My SQL statement like this
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
lateral view explode is supported by mysql and hiveql
Thank you
Metadata
Metadata
Assignees
Labels
No labels