今天学习到了一个沙箱的动态时间写法
如下
SELECT passenger_id
,COUNT(DISTINCT route_id) AS route_cnt
FROM pub_cockpit_db.dws_ord_route_p_detail_fact_ds
WHERE ds>=from_unixtime(unix_timestamp('${start_date}'),'yyyyMMdd')
AND ds<=from_unixtime(unix_timestamp('${end_date}'),'yyyyMMdd')
AND substr(settlement_time,1,10)>=from_unixtime(unix_timestamp('${start_date}'),'yyyy-MM-dd')
AND substr(settlement_time,1,10)<=from_unixtime(unix_timestamp('${end_date}'),'yyyy-MM-dd')
GROUP BY passenger_id
代码复制到堡垒机,下面弹出方框,填写start_date和end_date,即可跑出结果。方便快捷。