Timo Walther created FLINK-23319: ------------------------------------ Summary: Support semi/anti lookup joins Key: FLINK-23319 URL: https://issues.apache.org/jira/browse/FLINK-23319 Project: Flink Issue Type: New Feature Components: Table SQL / Planner Reporter: Timo Walther
Similar to FLINK-23305, we should also allow semi/anti joins for lookup joins such as: {code} SELECT T.* FROM MyTable AS T WHERE EXISTS ( SELECT * FROM LookupTable FOR SYSTEM_TIME AS OF T.proctime AS D WHERE T.a = D.id) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)