Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of ajo.fod@gmail.com designates
 74.125.82.176 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=SSROpPbCN57niUQEWtOM5FBz1w2HBkNuXc1QSS+aOpsRDvzUBMKVkppenSSxpe0YKe
         obIyrf/jdEI47F3OedMQ9qPLhOcgSFk5SkMWWstOUFSsEpo9WuKznE1ppQt440SULWAy
         ZscujsxQK6885LdRoeCkdmkETsumXl6PGMNwQ=
MIME-Version: 1.0
In-Reply-To: <AANLkTi=su9DHsSpbkm9fXDMU5rkuF=c8Q0TCuXiY9b94@mail.gmail.com>
References: <AANLkTi=OzWOe2B10KwaTj5pSHthfD8xCdJmRMdtcaV+-@mail.gmail.com>
	<AANLkTik02_eVJ-VwwKS+=+yE1-BfxS0+spgjgEVJ5OLr@mail.gmail.com>
	<AANLkTi=su9DHsSpbkm9fXDMU5rkuF=c8Q0TCuXiY9b94@mail.gmail.com>
Date: Thu, 20 Jan 2011 06:23:34 -0800
Message-ID: <AANLkTimtkNTNuEi7Noi6MqMHH_qtWHkvpeaBQP8ZmBP6@mail.gmail.com>
Subject: Re: Mapjoin Usage Question
From: Ajo Fod <ajo.fod@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

It probably depends on how big the big table is ... I mean if it can
be held in memory.

-Ajo

On Wed, Jan 19, 2011 at 11:23 PM, hadoop n00b <new2hive@gmail.com> wrote:
> Thanks Leo,
>
> Does the smaller table go into the mapjoin hint? Actually, when I ran a t=
est
> query with the bigger table in the hint, it performed better.
>
> On Thu, Jan 20, 2011 at 12:40 PM, Leo Alekseyev <dnquark@gmail.com> wrote=
:
>>
>> You can only specify one table, and make sure to include its name,
>> i.e. /*+ mapjoin(t2)*/. =A0 For more info see
>> http://wiki.apache.org/hadoop/Hive/JoinOptimization and
>> http://www.slideshare.net/aiolos127/join-optimization-in-hive.
>>
>> Also, you are using a relatively old version of Hive, but I'll let
>> more experienced people on this list decide whether that's a problem
>> :)
>>
>> On Thu, Jan 20, 2011 at 2:00 AM, hadoop n00b <new2hive@gmail.com> wrote:
>> > Hi,
>> >
>> > How do I use the mapjoin hint in a query.
>> >
>> > Say, I have two tables t1 and t2 where t2 is the smaller table. Do I
>> > specify
>> > t2 in the mapjoin hint?
>> >
>> > select /*+ mapjoin(b)*/ * from t1 join t2 b on (a.id =3D b.id)
>> >
>> > If I am joining two smaller tables, can I specify two clauses in the
>> > mapjoin? /*+mapjoin(b,c)*/?
>> >
>> > I am unable to find much documentation on this. I am using CDH2 with
>> > Hive
>> > 0.4.1
>> >
>> > Thanks!
>
>