select
tmp.*,
t.*,
date_add(start_date, pos) as mid_date
from(
select '1' as uid,
'2020-07-01' as start_date,
'2020-07-17' as end_date
)tmp
lateral view posexplode( split( space( datediff( end_date, start_date ) ), '' ) ) t as pos, val
;
HIVE列出两个日期之间的所有日期
最新推荐文章于 2024-08-28 04:18:08 发布