HIVE列出两个日期之间的所有日期

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
;