select 'dsf', regexp_replace(date_add(dt,row_number() over(order by dt) - 1),'-','') as dt
from (
select explode(split(rpad('2019-07-29',(datediff('2019-08-2','2019-07-29') + 1 )*11-1,',2019-07-29'),',')) as dt --rpad(目标,字符数,填充),每个',2019-07-20'是11字符,去掉第一个的‘,’号
) a