Return-Path: 
 <user-return-9291-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 63239DA8D
	for <apmail-hive-user-archive@www.apache.org>;
 Tue,  3 Jul 2012 03:25:51 +0000 (UTC)
Received: (qmail 12582 invoked by uid 500); 3 Jul 2012 03:25:50 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 12430 invoked by uid 500); 3 Jul 2012 03:25:49 -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 12388 invoked by uid 99); 3 Jul 2012 03:25:48 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jul 2012 03:25:48 +0000
X-ASF-Spam-Status: No, hits=1.8 required=5.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of abhishek.dodda1@gmail.com
 designates 209.85.160.176 as permitted sender)
Received: from [209.85.160.176] (HELO mail-gh0-f176.google.com)
 (209.85.160.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Jul 2012 03:25:39 +0000
Received: by ghbz10 with SMTP id z10so5567660ghb.35
        for <user@hive.apache.org>; Mon, 02 Jul 2012 20:25:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=subject:references:from:content-type:x-mailer:in-reply-to
         :message-id:date:to:content-transfer-encoding:mime-version;
        bh=I10oytsHDebOZ18WdXAnFB/YlijZh5+g/nWaWH1b/lU=;
        b=X3BIwXP3MU6pg5GdiM+IkDevH0oXq4KVm7JIpL9OPmgNsRHlB2FbjuCvCJG+zcyzcp
         dMnfgdWVSi+nwWJMjUfUqOnY0e8Fs9OM+//0GR5V4FE46J15aIwCpC6b0Wd1L7Y64WDQ
         5VStV0cpt0oLzfPw7YUTBy/hWhD//+fTs+hy25mrHee1Xh7L8vBFo5LjCIyvcukGvIr0
         Q9SqnNACL7SM5lXC36nAK+hvaG3ecMxPQKnq4LqeAkFpqHeTCu4W60Io3ubKdXifbaA3
         WeT4kXyU2Jzxpc57YBSO95Q23Q/W0v0K4Nph5biVgcy815qYrSCO6cMiPVaIUMWAXrbj
         Cz4A==
Received: by 10.236.187.2 with SMTP id x2mr18502095yhm.42.1341285919043;
        Mon, 02 Jul 2012 20:25:19 -0700 (PDT)
Received: from [10.48.169.238] (mobile-166-147-127-087.mycingular.net.
 [166.147.127.87])
        by mx.google.com with ESMTPS id i10sm13564434ang.5.2012.07.02.20.25.17
        (version=TLSv1/SSLv3 cipher=OTHER);
        Mon, 02 Jul 2012 20:25:18 -0700 (PDT)
Subject: Re: How to override a property with in a hive query
References: <D528219B-C56B-4445-8466-E9848BD18B5D@gmail.com>
 <29A497A0-6F2B-43D1-AC9E-A2AD412EB0AE@gmail.com>
 <CA+gx1wyvye7k0jGbmSvAzTqJyWEnYAdb=_eXGuUWpAVrfMT07g@mail.gmail.com>
From: Abhishek <abhishek.dodda1@gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-89AA8EE6-3B41-4BF9-8CEA-C9A1D0B7FA3E
X-Mailer: iPhone Mail (9B206)
In-Reply-To: 
 <CA+gx1wyvye7k0jGbmSvAzTqJyWEnYAdb=_eXGuUWpAVrfMT07g@mail.gmail.com>
Message-Id: <B1BB56BF-3147-4F66-9800-F1926F18DE1C@gmail.com>
Date: Mon, 2 Jul 2012 23:25:13 -0400
To: "user@hive.apache.org" <user@hive.apache.org>
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (1.0)
X-Virus-Checked: Checked by ClamAV on apache.org


--Apple-Mail-89AA8EE6-3B41-4BF9-8CEA-C9A1D0B7FA3E
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Hi Tim,

Is this the only way, or if we have any other ways.

Sent from my iPhone

On Jul 2, 2012, at 8:49 PM, Tim Havens <timhavens@gmail.com> wrote:

> Before your query type SET <property> =3D <blah>;
>=20
> On Mon, Jul 2, 2012 at 7:13 PM, Abhishek <abhishek.dodda1@gmail.com> wrote=
:
> Hi all,
>=20
> Can I know, how to override a property of mapred-site.xml in Hive join que=
ry.
> Suppose for map reduce job we override using -D <property name=3Dvalue>, h=
ow to do it with in hive query.
>=20
> Regards
> Abhishek.
>=20
>=20
> Begin forwarded message:
>=20
>> From: Abhishek <abhishek.dodda1@gmail.com>
>> Date: July 2, 2012 8:10:47 PM EDT
>> To: "user@hive.apache.org" <user@hive.apache.org>
>> Subject: How to a property in hive query
>>=20
>> Hi all,
>>=20
>> Can I know, how to override a property of mapred-site.xml in Hive join qu=
ery.
>> Suppose for map reduce job we override using -D <property name=3Dvalue>, h=
ow to do it with in hive query.
>=20
>=20
>=20
> --=20
> "The whole world is you. Yet you keep thinking there is something else." -=
 Xuefeng Yicun 822-902 A.D.
>=20
> Tim R. Havens
> Google Phone: 573.454.1232
> ICQ: 495992798
> ICBM:  37=C2=B051'34.79"N   90=C2=B035'24.35"W
> ham radio callsign: NW0W

--Apple-Mail-89AA8EE6-3B41-4BF9-8CEA-C9A1D0B7FA3E
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head></head><body bgcolor=3D"#FFFFFF"><div>Hi Tim,</div><div><br></di=
v><div>Is this the only way, or if we have any other ways.</div><div><br>Sen=
t from my iPhone</div><div><br>On Jul 2, 2012, at 8:49 PM, Tim Havens &lt;<a=
 href=3D"mailto:timhavens@gmail.com">timhavens@gmail.com</a>&gt; wrote:<br><=
br></div><div></div><blockquote type=3D"cite"><div>Before your query type SE=
T &lt;property&gt; =3D &lt;blah&gt;;<br><br><div class=3D"gmail_quote">On Mo=
n, Jul 2, 2012 at 7:13 PM, Abhishek <span dir=3D"ltr">&lt;<a href=3D"mailto:=
abhishek.dodda1@gmail.com" target=3D"_blank">abhishek.dodda1@gmail.com</a>&g=
t;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><div bgcolor=3D"#FFFFFF"><div>Hi all,<br><span=
></span><br><span>Can I know, how to override a property of mapred-site.xml i=
n Hive join query.</span><br>
<span>Suppose for map reduce job we override using -D &lt;property name=3Dva=
lue&gt;, how to do it with in hive query.</span><br><br>Regards</div><div>Ab=
hishek.<br><br></div><div><br>Begin forwarded message:<br><br></div><blockqu=
ote type=3D"cite">
<div><b>From:</b> Abhishek &lt;<a href=3D"mailto:abhishek.dodda1@gmail.com" t=
arget=3D"_blank">abhishek.dodda1@gmail.com</a>&gt;<br><b>Date:</b> July 2, 2=
012 8:10:47 PM EDT<br><b>To:</b> "<a href=3D"mailto:user@hive.apache.org" ta=
rget=3D"_blank">user@hive.apache.org</a>" &lt;<a href=3D"mailto:user@hive.ap=
ache.org" target=3D"_blank">user@hive.apache.org</a>&gt;<br>
<b>Subject:</b> <b>How to a property in hive query</b><br><br></div></blockq=
uote><blockquote type=3D"cite"><span>Hi all,</span><br><span></span><br><spa=
n>Can I know, how to override a property of mapred-site.xml in Hive join que=
ry.</span><br>
<span>Suppose for map reduce job we override using -D &lt;property name=3Dva=
lue&gt;, how to do it with in hive query.</span><br></blockquote><div></div>=
</div></blockquote></div><br><br clear=3D"all"><div><br></div>-- <br>"The wh=
ole world is you. Yet you keep thinking there is something else." - Xuefeng Y=
icun 822-902 A.D.<br>
<br>Tim R. Havens<br>Google Phone: 573.454.1232<br>ICQ: 495992798<br>ICBM:&n=
bsp; 37=C2=B051'34.79"N&nbsp;&nbsp; 90=C2=B035'24.35"W<br>ham radio callsign=
: NW0W<br>
</div></blockquote></body></html>=

--Apple-Mail-89AA8EE6-3B41-4BF9-8CEA-C9A1D0B7FA3E--