spark sql 生成指定区间的日期

永远相信神话

已于 2022-08-21 20:00:01 修改

阅读量3.9k

点赞数 3

分类专栏： bigData 文章标签： spark sql

于 2022-04-19 13:54:11 首次发布

本文链接：https://blog.youkuaiyun.com/li93675/article/details/124270197

版权

spark sql生成指定连续区间的日期，如 2021-12-29 到 2021-12-31 之间的日期, 也可指定具体的开始和结束日期，只需修改开始时间和结束时间即可

    spark.sql(
      """
        |select date_add(date_add(end_date, diff), a.pos) as date
        |from
        | (
        |	  select posexplode(split(repeat(" ", datediff(end_date, date_add(end_date, diff))), " ")),
        |           end_date,
        |           diff
        |   from
        |     (
        |       select start_date, end_date, datediff(start_date,end_date) diff from
        |           (
        |             select '2021-12-29' as start_date,'2021-12-31' as end_date
        |           )
        |     )
        | )a
        |""".stripMargin).show()