Hive列出两个日期范围内的所有日期

1. 先要算出日期范围的天数=结束日期-开始日期
2. 把天数数组化
3. 使用lateral view posexpload ，一行变多行
4. 把开始日期+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