一共有job数为:86
周期可以重复计算
where month(send_time)=month('{STAT_DATE}')-1
当month为1时,会得出结果为0.
所以要改为:
where month(send_time)=case (month('{STAT_DATE}')-1 ) when 0 then 12
CASE weekofyear('2013-01-01') WHEN 0 THEN weekofyear(concat_ws('-',cast(year('2013-01-01')-1 as string),'12','31')) WHEN 1 THEN (weekofyear(concat_ws('-',year('2013-01-01')-1,'12','31'))-1) ELSE weekofyear('2013-01-01') END, IF(weekofyear('2013-01-01')<2, year('2013-01-01')-1, year('2013-01-01'))
where weekofyear(send_time)=weekofyear(date_sub('{STAT_DATE}',7)) and year(send_time)=year(date_sub('{STAT_DATE}',7))