I think hive.mapjoin.smalltable.filesize parameter will be disregarded in that case.
On Thu, Feb 14, 2013 at 7:25 AM, Mayuresh Kunjir <mayuresh.kun...@gmail.com>wrote: > 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" >> > -- "...:::Aniket:::... Quetzalco@tl"
