Hi, I saw that, but haven¹t got any time to run an EXPLAIN yet.
Filter push-down cases are generally all down to hive.optimize.ppd=true; - everything becomes clearer when you look at an explain. If I had to guess, I¹d say that the new JOIN syntax won¹t have this bug. select from a,b,c where a.id = b.id, c.x = b.x; Cheers, Gopal On 5/28/15, 10:57 AM, "Alexander Pivovarov" <apivova...@gmail.com> wrote: >Hi Everyone > >Couple days ago I stepped on one strange issue - "WHERE col is not null" >does not work for one query. > >Details are here https://issues.apache.org/jira/browse/HIVE-10841 > >What you think? How critical is it?