flink sql 如何实现双流join 的滑动窗口？

打扰大家了。请教下如何实现双流join的滑动窗口。我的代码运行后就报错了。有经验的同学帮忙解答下。谢谢。

代码： SELECT TUMBLE_START(a.ts, INTERVAL '10' MINUTE), TUMBLE_END(a.ts, INTERVAL '10' MINUTE), sum( CASE WHEN f.business_id <> NULL THEN 1 ELSE 0 END ) AS company_pass_first_num, sum( CASE WHEN g.business_id <> NULL THEN 1 ELSE 0 END ) AS company_pass_num, COUNT(a.create_time) FROM t1_oa_loan_requests_detail_view a LEFT JOIN t1_oa_flow_inst_task_view_segment_no_5 f ON a.id = f.business_id LEFT JOIN t1_oa_flow_inst_task_view_segment_no_61 g ON a.id = g.business_id GROUP BY TUMBLE(a.ts, INTERVAL '10' MINUTE);

报错： [ERROR] Could not execute SQL statement. Reason: org.apache.flink.table.api.TableException: Rowtime attributes must not be in the input rows of a regular join. As a workaround you can cast the time attributes of input tables to TIMESTAMP before.*来自志愿者整理的FLINK邮件归档