ah never mind I found that we are using an old version of hive without this feature
On Tue, Mar 8, 2016 at 9:57 AM, Yang <teddyyyy...@gmail.com> wrote: > 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? >> > >
