[FLINK-15077] Support Semi/Anti LookupJoin in Blink planner

• Type: New Feature
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / Planner
• Labels: auto-deprioritized-major auto-deprioritized-minor auto-unassigned
• Assignee: Unassigned
• Reporter: Jing Zhang
• Created: 05/Dec/19 11:41
• Updated: 15/Jul/22 22:37

Description

Support the following sql in Blink planner:

SELECT T.id, T.len, T.content FROM T WHERE T.id IN (
  SELECT id FROM csvDim FOR SYSTEM_TIME AS OF PROCTIME() AS D)

SELECT T.id, T.len, T.content FROM T WHERE EXISTS (
  SELECT * FROM csvDim FOR SYSTEM_TIME AS OF PROCTIME() AS D WHERE T.id = D.id)

SELECT T.id, T.len, T.content FROM T WHERE NOT EXISTS (
  SELECT * FROM csvDim FOR SYSTEM_TIME AS OF PROCTIME() AS D WHERE T.id = D.id)

Issue Links

• is duplicated by: FLINK-23319 Support semi/anti lookup joins