如何以编程方式从星火sql中的日期中减去天数?fromwhere partition_date between ('$date'-6) and '$date'""")val tmp = spark.sql(""" count(distinct purchase_id) as count_purchasesmy_table
where
嗨,我有"sql查询“来查看上周为每个成员完成的工作的数量,所以我创建了"sql query”,这是非常愿意的,但是我想将week1或week2的更改为本周的--我的"sql查询“是: SUM(if (created_at BETWEEN NOW()-INTERVAL 1 WEEK AND NOW(), 1,0)) SUM(if(created_at BETWEEN NOW()-INTERVAL 2 W