1.presto 表连接查询的连接条件中不支持使用函数
比如下面的脚本在presto中运行会报错
select t1.period_start_date, t2.statistic_date from (select distinct calendar_date as period_start_date, calendar_date as period_end_date from edw_public.dim_esf_edw_pub_date where calendar_date >= '${开始时间}' and calendar_date <= '${结束时间}' ) t1 left join (select statistic_date ,xf_agent_id as agent_id from edw_agents.adm_xf_edw_agents_performance_daily_report_edw_001_di where 1=1 ) t2 on date(statistic_date) <= period_start_date and date(statistic_date) <= period_end_date但是只要把连接条件中的date函数去掉则可以正常运行
select t1.period_start_date, t2.statistic_date from (select distinct calendar_date as period_start_date, calendar_date as period_end_date from edw_public.dim_esf_edw_pub_date where calendar_date >= '${开始时间}' and calendar_date <= '${结束时间}' ) t1 left join (select statistic_date ,xf_agent_id as agent_id from edw_agents.adm_xf_edw_agents_performance_daily_report_edw_001_di where 1=1 ) t2 on statistic_date <= period_start_date and statistic_date <= period_end_date
转载于:https://www.cnblogs.com/shujuxiong/p/10006378.html
