[ https://issues.apache.org/jira/browse/FLINK-23305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17432420#comment-17432420 ]
xuyangzhong commented on FLINK-23305: ------------------------------------- I'll try to fix these issue. (FLINK-23305 / FLINK-23319 / FLINK-23320) > Support semi/anti interval joins > -------------------------------- > > Key: FLINK-23305 > URL: https://issues.apache.org/jira/browse/FLINK-23305 > Project: Flink > Issue Type: New Feature > Components: Table SQL / Planner > Reporter: Timo Walther > Priority: Major > > I don't see a reason why we shouldn't support interval joins also for > semi/anti joins like: > {code} > SELECT * > FROM OT > WHERE EXISTS ( > SELECT * > FROM TT > WHERE TT.tx = OT.tx AND > TT.isEnd = TRUE AND > TT.rowtime BETWEEN OT.rowtime AND OT.rowtime + INTERVAL '1' HOUR) > {code} > The resulting plan contains a join operation anyway but without detecting the > interval. -- This message was sent by Atlassian Jira (v8.3.4#803005)