在BigQuery中插入未来7天的日期

Question

我有一个数据集，我必须插入一个日期列与未来7天的日期在它。我该怎么做呢?

SELECT invite_date
FROM UNNEST(
GENERATE_DATE_ARRAY(current_date(), DATE_ADD(current_date(), INTERVAL 7 DAY), INTERVAL 1 DAY)
) AS invite_date

上面的查询返回7天的日期。我如何在每一行中插入这些日期并且每个日期的行数相等

Answer 1

我想这应该有帮助:

WITH sample_data AS (
SELECT * FROM UNNEST([
STRUCT<one STRING, two INT64, three FLOAT64, four DATE>
("a", 2018, 0.1, '2022-12-01'),
('b', 2017, 1.1, '2022-11-01'),
('c', 2016, 5.2, '2022-10-01'),
('d', 2015, 4.9, '2022-09-01')
]))
SELECT *, GENERATE_DATE_ARRAY(CURRENT_DATE(), DATE_ADD(CURRENT_DATE(), INTERVAL 7 DAY), interval 1 DAY) AS invite_date
FROM sample_data