Re: Relativity simple query returns incorrect result

2015-05-28 Thread Alexander Pivovarov
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 wrote: > Hi, > > I saw that, but haven¹t got any time to run an EXPLAIN yet. > > Filter push-down cases are generally all do

Re: Relativity simple query returns incorrect result

2015-05-28 Thread Gopal Vijayaraghavan
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

Relativity simple query returns incorrect result

2015-05-28 Thread Alexander Pivovarov
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?