SELECT DATE_ADD(start_date, pos) dd
FROM (SELECT ‘2022-03-01’ AS start_date, ‘2022-03-30’ AS end_date) temp
LATERAL VIEW
POSEXPLODE(SPLIT(SPACE(DATEDIFF(end_date, start_date)), ‘’)) t
AS pos, val
hql创建指定日期表
最新推荐文章于 2024-04-02 16:31:57 发布
SELECT DATE_ADD(start_date, pos) dd
FROM (SELECT ‘2022-03-01’ AS start_date, ‘2022-03-30’ AS end_date) temp
LATERAL VIEW
POSEXPLODE(SPLIT(SPACE(DATEDIFF(end_date, start_date)), ‘’)) t
AS pos, val