SELECT
TD_TIME_FORMAT(TD_TIME_ADD(TD_SCHEDULED_TIME(), CONCAT('-',s.s,'d')), 'yyyy-MM-dd','JST') AS d
FROM (
SELECT
GENERATE_SERIES(0, 7) AS s
) AS s
ネタ元
https://developers.eure.jp/tech/mysql_tips1/
SELECT
DATE_FORMAT(DATE_SUB(NOW(), INTERVAL series_numbers.number DAY),'%Y-%m-%d') AS date
FROM (
SELECT @num := 0 AS number
UNION ALL
SELECT @num := @num + 1 FROM information_schema.COLUMNS
LIMIT 7
) AS series_numbers
ドキュメント
https://docs.treasuredata.com/articles/hive-hivemall#generateseries
ネタ元
http://laughingman7743.hatenablog.com/entry/2016/12/11/004308