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)