Yes, the hint was specified. On Feb 14, 2013 3:11 AM, "Aniket Mokashi" <aniket...@gmail.com> 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 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" >
