by documentation I'm referring to this: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins#LanguageManualJoins-MapJoinRestrictions
" the following configurable parameters can be used to make sure that the query executes in a single map-reduce job." On Tue, Mar 8, 2016 at 9:31 AM, Yang <teddyyyy...@gmail.com> wrote: > From the documentation it says that if my tables are small enough and i > set the conver join parameters, without the join hints hive should be able > to convert the joins into 1 mapjoin in 1 mr job > > But in practice i found that it always ends up in 2 mr jobs (2 map joins). > What is wrong? >