Return-Path: 
 <dev-return-30623-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-dev-archive@www.apache.org
Delivered-To: apmail-hive-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 602159ACF
	for <apmail-hive-dev-archive@www.apache.org>;
 Tue, 31 Jan 2012 17:32:32 +0000 (UTC)
Received: (qmail 31722 invoked by uid 500); 31 Jan 2012 17:32:32 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 31587 invoked by uid 500); 31 Jan 2012 17:32:31 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 31573 invoked by uid 99); 31 Jan 2012 17:32:31 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2012 17:32:31 +0000
X-ASF-Spam-Status: No, hits=1.7 required=5.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of
 bharathvissapragada1990@gmail.com designates 209.85.216.41 as permitted
 sender)
Received: from [209.85.216.41] (HELO mail-qw0-f41.google.com) (209.85.216.41)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2012 17:14:05 +0000
Received: by qadz32 with SMTP id z32so3184356qad.14
        for <dev@hive.apache.org>; Tue, 31 Jan 2012 09:13:45 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        bh=F6CD5sYbx+Owwby3QC1k7FblqWZ/iDSRrDl1Shm8V4U=;
        b=KGJjLz9WyDo0HeHVh4A3JWRQ/lm1PHfx8cr9QOZKCLT9y+isMvyg/beI+sjwgmaUhl
         GsTGsI7+mG6YWDRM4aLtB/4wUBCZL5dYfsi/UBhSq2RdTkv3DAKUpOa4IvkJRxVpsboL
         lkmEGH+SzzmQlS52CzZpVl8iCblwRqhShpPsQ=
Received: by 10.229.77.5 with SMTP id e5mr8402981qck.99.1328030024395; Tue, 31
 Jan 2012 09:13:44 -0800 (PST)
MIME-Version: 1.0
Received: by 10.229.211.75 with HTTP; Tue, 31 Jan 2012 09:13:24 -0800 (PST)
In-Reply-To: 
 <CAO=S9O-GXRx+Zp_=vM82Qvhs1pV5-G1DzaC9o9ownm0-P3Uujg@mail.gmail.com>
References: 
 <CAO=S9O-GXRx+Zp_=vM82Qvhs1pV5-G1DzaC9o9ownm0-P3Uujg@mail.gmail.com>
From: bharath vissapragada <bharathvissapragada1990@gmail.com>
Date: Tue, 31 Jan 2012 18:13:24 +0100
Message-ID: 
 <CAK3hZ7TTPx8+axh5VM_wRoEWCfUjg4RaduBfMjeuMcLHqUXGXg@mail.gmail.com>
Subject: Re: Who can I get the MapReduce Jobs codes generated by Hive
 Compiler?
To: dev@hive.apache.org
Content-Type: multipart/alternative; boundary=0023544710d0daedff04b7d6155f
X-Virus-Checked: Checked by ClamAV on apache.org

--0023544710d0daedff04b7d6155f
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hey,

Explain command is what you need . Just type "explain <query>" in the
console and it dumps the entire plan to the screen. You can analyze it and
get the plan generated by hive.

Thanks

On Tue, Jan 31, 2012 at 4:57 PM, Alexis De La Cruz Toledo <
alexisdct@gmail.com> wrote:

> Hi I'd like to know what is the code generated by
> the compiler of SQL hive. i.e. If I execute one sql sentence
> I'd like to see the code of MapReduce jobs generated by compiler of SQL
> hive.
>
> Who can I get it?
>
> Thanks.
> --
> Ing. Alexis de la Cruz Toledo.
> *Av. Instituto Polit=E9cnico Nacional No. 2508 Col. San Pedro Zacatenco.
> M=E9xico,
> D.F, 07360 *
> *CINVESTAV, DF.*
>



--=20
Regards,
Bharath .V
w:http://researchweb.iiit.ac.in/~bharath.v

--0023544710d0daedff04b7d6155f--