Relativity simple query returns incorrect result
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?
Re: Relativity simple query returns incorrect result
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?
Re: Relativity simple query returns incorrect result
I just added 2.1 explain select ... output for hive-1.3.0 MR 2.2. explain select... output for hive-0.13.1 Tez On Thu, May 28, 2015 at 11:08 AM, Gopal Vijayaraghavan gop...@apache.org wrote: 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?