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 18:25:05 GMT
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 <teddyyyy123@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 <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