e typos
>> --
>> *From: * Mayuresh Kunjir
>> *Date: *Fri, 15 Feb 2013 10:37:52 -0500
>> *To: *user
>> *ReplyTo: * user@hive.apache.org
>> *Subject: *Re: Map join optimization issue
>>
>> Thanks Aniket. I actually had no
lowing would suffice the purpose
>
> Set hive.auto.convert.join=true
> Regards
> Bejoy KS
>
> Sent from remote device, Please excuse typos
> --
> *From: * Mayuresh Kunjir
> *Date: *Fri, 15 Feb 2013 10:37:52 -0500
> *To: *user
> *Repl
i, 15 Feb 2013 10:37:52
To: user
Reply-To: user@hive.apache.org
Subject: Re: Map join optimization issue
Thanks Aniket. I actually had not specified the map-join hint though. Sorry
for providing the wrong information earlier. I had only
set hive.auto.convert.join=true before firing my join
Thanks Aniket. I actually had not specified the map-join hint though. Sorry
for providing the wrong information earlier. I had only
set hive.auto.convert.join=true before firing my join query.
~Mayuresh
On Thu, Feb 14, 2013 at 10:44 PM, Aniket Mokashi wrote:
> I think hive.mapjoin.smalltable.f
I think hive.mapjoin.smalltable.filesize parameter will be disregarded in
that case.
On Thu, Feb 14, 2013 at 7:25 AM, Mayuresh Kunjir
wrote:
> Yes, the hint was specified.
> On Feb 14, 2013 3:11 AM, "Aniket Mokashi" wrote:
>
>> have you specified map-join hint in your query?
>>
>>
>> On Thu, Fe
Yes, the hint was specified.
On Feb 14, 2013 3:11 AM, "Aniket Mokashi" wrote:
> have you specified map-join hint in your query?
>
>
> On Thu, Feb 7, 2013 at 11:39 AM, Mayuresh Kunjir <
> mayuresh.kun...@gmail.com> wrote:
>
>>
>> Hello all,
>>
>>
>> I am trying to join two tables, the smaller bein
have you specified map-join hint in your query?
On Thu, Feb 7, 2013 at 11:39 AM, Mayuresh Kunjir
wrote:
>
> Hello all,
>
>
> I am trying to join two tables, the smaller being of size 4GB. When I set
> hive.mapjoin.smalltable.filesize parameter above 500MB, Hive tries to
> perform a local task to
Hello all,
I am trying to join two tables, the smaller being of size 4GB. When I set
hive.mapjoin.smalltable.filesize parameter above 500MB, Hive tries to
perform a local task to read the smaller file. This of-course fails since
the file size is greater and the backup common join is then run. Wha
