hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aniket Mokashi <aniket...@gmail.com>
Subject Re: Map join optimization issue
Date Thu, 14 Feb 2013 08:11:19 GMT
have you specified map-join hint in your query?


On Thu, Feb 7, 2013 at 11:39 AM, Mayuresh Kunjir
<mayuresh.kunjir@gmail.com>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 read the smaller file. This of-course fails since
> the file size is greater and the backup common join is then run. What I do
> not understand is why did Hive attempt a map join when small file size was
> greater than the smalltable.filesize parameter.
>
>
> ~Mayuresh
>
>


-- 
"...:::Aniket:::... Quetzalco@tl"

Mime
View raw message