[jira] [Created] (FLINK-15077) Support Semi/Anti LookupJoin in Blink planner

[Shang Yuanchun (Jira)]

Jing Zhang created FLINK-15077:
----------------------------------

             Summary: Support Semi/Anti LookupJoin in Blink planner
                 Key: FLINK-15077
                 URL: https://issues.apache.org/jira/browse/FLINK-15077
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
            Reporter: Jing Zhang


Support the following sql in Blink planner:

{code:sql}
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)
{code}

{code:sql}
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)
{code}

{code:sql}
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)
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)