Return-Path: 
 <user-return-4804-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: (qmail 39099 invoked from network); 20 Jan 2011 07:01:20 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 20 Jan 2011 07:01:20 -0000
Received: (qmail 27208 invoked by uid 500); 20 Jan 2011 07:01:20 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 27021 invoked by uid 500); 20 Jan 2011 07:01:17 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 27013 invoked by uid 99); 20 Jan 2011 07:01:16 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jan 2011 07:01:16 +0000
X-ASF-Spam-Status: No, hits=1.5 required=10.0
	tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of new2hive@gmail.com designates
 209.85.212.176 as permitted sender)
Received: from [209.85.212.176] (HELO mail-px0-f176.google.com)
 (209.85.212.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jan 2011 07:01:11 +0000
Received: by pxi11 with SMTP id 11so55980pxi.35
        for <user@hive.apache.org>; Wed, 19 Jan 2011 23:00:50 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:date:message-id:subject:from:to
         :content-type;
        bh=Bu76DVxyfE39KEQyYbkshO87Of0ijmY0RMbXLrhwv+c=;
        b=LWLjvsfHo+dijmiDStjhxrJZQNnvrfCG0eO59Wat3AI7/K5H1atzhRdhP3WLDk8Q1W
         9MDzL8v0VqsOg/EFJI1hdbgsdFtRnLHkURIxBgzs9LzZXNHc47FR5acRyEYBdV5BvsTH
         fZtVRBThZXk8tYVJK4Y0KnVha98+jlYd1pPPM=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=jO60OQf1+J2xD2XtCbFIKR5WUjq8mjBY/2k51JVjnvMyutA80vv+ZGMo46X14NGTEY
         d53DbPnEy/y1s9TulMVubCQ5dXWAeaqsNePAfebATqYGSolycaFupp1RYape6+IOTyqP
         rpSkS9LVF1wNcfuPaKHSv5BlS515DGuKeTXyM=
MIME-Version: 1.0
Received: by 10.142.52.2 with SMTP id z2mr1753609wfz.202.1295506850516; Wed,
 19 Jan 2011 23:00:50 -0800 (PST)
Received: by 10.142.238.5 with HTTP; Wed, 19 Jan 2011 23:00:50 -0800 (PST)
Date: Thu, 20 Jan 2011 12:30:50 +0530
Message-ID: <AANLkTi=OzWOe2B10KwaTj5pSHthfD8xCdJmRMdtcaV+-@mail.gmail.com>
Subject: Mapjoin Usage Question
From: hadoop n00b <new2hive@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=000e0cd24508a10f9f049a41b1ca

--000e0cd24508a10f9f049a41b1ca
Content-Type: text/plain; charset=ISO-8859-1

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 = 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!

--000e0cd24508a10f9f049a41b1ca
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi,</div>
<div>=A0</div>
<div>How do I use the mapjoin hint in a query.</div>
<div>=A0</div>
<div>Say, I have two tables t1 and t2 where t2 is the smaller table. Do I s=
pecify t2 in the mapjoin hint?</div>
<div>=A0</div>
<div>select /*+ mapjoin(b)*/ * from t1 join t2 b on (<a href=3D"http://a.id=
">a.id</a> =3D <a href=3D"http://b.id">b.id</a>)</div>
<div>=A0</div>
<div>If I am joining two smaller tables, can I specify two clauses in the m=
apjoin? /*+mapjoin(b,c)*/?</div>
<div>=A0</div>
<div>I am unable to find much documentation on this. I am using CDH2 with H=
ive 0.4.1</div>
<div>=A0</div>
<div>Thanks!</div>

--000e0cd24508a10f9f049a41b1ca--