hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yang <teddyyyy...@gmail.com>
Subject Re: Big + small + small 3 table mapjoin?
Date Tue, 08 Mar 2016 17:57:24 GMT
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 <teddyyyy123@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?
>

Mime
View raw message