- 先要算出日期范围的天数=结束日期-开始日期
- 把天数数组化
- 使用lateral view posexpload ,一行变多行
- 把开始日期+index
SELECT t2.start_date,t2.end_date,x,y,date_add(start_date,x) as date from (
SELECT start_date,end_date,datediff(end_date,start_date) as diff,split(space(datediff(end_date,start_date)),'') as day_num from (
SELECT '2022-06-01' as start_date, '2022-06-05' as end_date
union all
SELECT '2022-06-04' as start_date, '2022-06-11' as end_date
) t1
) t2 lateral view posexplode(day_num) t3 as x,y