You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Alexander Pivovarov <ap...@gmail.com> on 2015/05/28 19:57:41 UTC
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
Posted by Alexander Pivovarov <ap...@gmail.com>.
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 <go...@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" <ap...@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
Posted by Gopal Vijayaraghavan <go...@apache.org>.
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" <ap...@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?