Timo Walther created FLINK-23305:
------------------------------------
Summary: 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
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)
