用纯SQL在dataworks生成连续的时间
案例
开始日期:2021-01-01
结束日期:2021-01-05
生成结果:
2021-01-01
2021-01-02
2021-01-03
2021-01-04
2021-01-05
select a.id,date_add(starttime,idx) as date1
from (
select
id
,starttime
,endtime
from tmp.sgy_product
)a
lateral view posexplode(split(space(datediff(endtime,starttime)),'')) t as idx,dat