Hive列出两个日期之间的所有日期
hive表示出两个日期之间的所有日期,mapping出来
select
tmp.*,
t.*,
date_add(start_date, pos) as mid_date
from(
select
'1' as uid,
'2020-01-01' as start_date,
'2020-01-05' as end_date
) tmp lateral view posexplode(
split(space(datediff(end_date, start_date)), '')
) t as pos,
val