[ https://issues.apache.org/jira/browse/FLINK-15077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kurt Young updated FLINK-15077: ------------------------------- Issue Type: New Feature (was: Bug) > Support Semi/Anti LookupJoin in Blink planner > --------------------------------------------- > > Key: FLINK-15077 > URL: https://issues.apache.org/jira/browse/FLINK-15077 > Project: Flink > Issue Type: New Feature > Components: Table SQL / Planner > Reporter: Jing Zhang > Assignee: Jing Zhang > Priority: Major > > 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)