Hi, if you decorrelate the subquery, you can execute EXIST or NOT EXIST with a join or co group.
If you search for "subquery decorrelation" you will find a good amount of information. Note that subquery decorrelation is not possble in general. Queries with subqueries that cannot be decorrelated cannot be executed efficiently by Flink (and other parallel system struggle with that as well). cheers, Fabian 2015-07-07 16:26 GMT+02:00 hagersaleh <loveallah1...@yahoo.com>: > please help > > > > -- > View this message in context: > http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/How-can-handles-Exist-not-Exist-query-on-flink-tp1939p1973.html > Sent from the Apache Flink User Mailing List archive. mailing list archive > at Nabble.com. >