hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gautam <gautamkows...@gmail.com>
Subject Re: nested join issue
Date Sat, 13 Jun 2015 06:31:13 GMT
Found that turning off hive.optimize.remove.identity.project ( ref:
HIVE-8435 <https://issues.apache.org/jira/browse/HIVE-8435> ) fixes the
issue.

This gives us a workaround, but dunno the performance degradation this
impacts yet.

Thanks!
-Gautam.


On Fri, Jun 12, 2015 at 6:02 PM, Gautam <gautamkowshik@gmail.com> wrote:

> Done. https://issues.apache.org/jira/browse/HIVE-10996
>
> On Fri, Jun 12, 2015 at 1:47 PM, Gopal Vijayaraghavan <gopalv@apache.org>
> wrote:
>
>> Hi
>>
>> > Thanks for investigating..  Trying to locate the patch that fixes this
>> >between 1.1 and 2.0.0-SNAPSHOT. Any leads on what Jira this fix was part
>> >of? Or what part of the code the patch is likely to be on?
>>
>> git bisect is the only way usually to identify these things.
>>
>> But before you hunt into the patches I suggest trying combinations of
>> constant propogation, null-scan and identity projection remover
>> optimizations to see if thereĀ¹s a workaround in there.
>>
>> An explain of the query added to a new JIRA would be good, to continue the
>> analysis.
>>
>> Cheers,
>> Gopal
>>
>>
>>
>
>
> --
> "If you really want something in this life, you have to work for it. Now,
> quiet! They're about to announce the lottery numbers..."
>



-- 
"If you really want something in this life, you have to work for it. Now,
quiet! They're about to announce the lottery numbers..."

Mime
View raw message