Return-Path: 
 <user-return-16626-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 0359A11403
	for <apmail-hive-user-archive@www.apache.org>;
 Mon, 16 Jun 2014 18:58:37 +0000 (UTC)
Received: (qmail 36896 invoked by uid 500); 16 Jun 2014 18:58:35 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 36829 invoked by uid 500); 16 Jun 2014 18:58:35 -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 36819 invoked by uid 99); 16 Jun 2014 18:58:35 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jun 2014 18:58:35 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of zhou.jinyuan@gmail.com
 designates 209.85.214.170 as permitted sender)
Received: from [209.85.214.170] (HELO mail-ob0-f170.google.com)
 (209.85.214.170)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jun 2014 18:58:32 +0000
Received: by mail-ob0-f170.google.com with SMTP id uz6so6192077obc.15
        for <user@hive.apache.org>; Mon, 16 Jun 2014 11:58:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=F8PnYQmyzDsyaKIwNNxOn9MW97zXLYxMnd0niOT/24c=;
        b=qbD0x5Qp3joCqZq/OBQOCS7m3GVn+WF/YNa1DAKbDU+uTlA8wTPdbFsH0UHgJtkff2
         r3E+ObUJnGmkiXEHSyXV2Z8eg7YBZYH/8JHvX7yLdqDecD4+K64Vv6BRtNcr+Md3Agzc
         ecJSqAMjdX1yMywvERQI3k+7HtJ7WcGwxtCx1i6zhAL2i5hXcyUGGAP/jXQzXQWXH9eA
         2EhDSAAo9RiHLf4dNfYhC5yak6SvfL5/myTlw9IQvJkQalEeqBQKy0RMEydmk19Oujr9
         tNLsOu23cBZrB15TDsBcqrCVb7HweDax+qudtQAeoywZ9+nyFXsRlzC3psUAuWy1rozh
         YliQ==
MIME-Version: 1.0
X-Received: by 10.60.179.80 with SMTP id de16mr4205124oec.69.1402945088387;
 Mon, 16 Jun 2014 11:58:08 -0700 (PDT)
Received: by 10.182.202.5 with HTTP; Mon, 16 Jun 2014 11:58:08 -0700 (PDT)
In-Reply-To: 
 <CACiS8CzxUVOM+O+3XR8XFqdOeiU3BVJ_aXCwhGHDhmry=Gk_MQ@mail.gmail.com>
References: 
 <CANBTPCFqgtXcCpVdmh91btPcBuQoyg2bAb-FRiggOiX+PEOpKw@mail.gmail.com>
	<CACiS8CzxUVOM+O+3XR8XFqdOeiU3BVJ_aXCwhGHDhmry=Gk_MQ@mail.gmail.com>
Date: Mon, 16 Jun 2014 11:58:08 -0700
Message-ID: 
 <CANBTPCELxiOs1UJpRPh7S=c=d+Xa+7VbiTn7T8B4E_2_T_vLrA@mail.gmail.com>
Subject: Re: hive cli configuration quesiton
From: Jinyuan Zhou <zhou.jinyuan@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=089e0118243aa25cfd04fbf89bff
X-Virus-Checked: Checked by ClamAV on apache.org

--089e0118243aa25cfd04fbf89bff
Content-Type: text/plain; charset=UTF-8

Thanks Douglas,
This should solve my problem.
Regards

Jinyuan (Jack) Zhou


On Mon, Jun 16, 2014 at 11:55 AM, Douglas Moore <
douglas.moore@thinkbiganalytics.com> wrote:

> Hive CLI has a -i <file> option. We create a pre.sql file with hive
> settings and then specify:
> hive -i pre.hql -f query.hql
>
>
>
> On Mon, Jun 16, 2014 at 2:52 PM, Jinyuan Zhou <zhou.jinyuan@gmail.com>
> wrote:
>
>> Hi,
>> I like to include common settings in one place when I run different hql
>> script via hive cli.
>> My setting is really script specific, with my understanding of hive,
>> hadoop,  it is not very appropriate to put  these settings in
>> hive-site.xml, or hadoop configruation files. I don't want to repeat these
>> settings in every hql script either. I know pig has a mechinizsm to
>> importing pig script into another script. Is there similar mechnism for
>> hive?
>> Thanks,
>>
>> --
>> -- Jinyuan (Jack) Zhou
>>
>

--089e0118243aa25cfd04fbf89bff
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks Douglas,<div>This should solve my problem.</div><di=
v>Regards</div></div><div class=3D"gmail_extra"><br clear=3D"all"><div><div=
 dir=3D"ltr">Jinyuan (Jack) Zhou</div></div>
<br><br><div class=3D"gmail_quote">On Mon, Jun 16, 2014 at 11:55 AM, Dougla=
s Moore <span dir=3D"ltr">&lt;<a href=3D"mailto:douglas.moore@thinkbiganaly=
tics.com" target=3D"_blank">douglas.moore@thinkbiganalytics.com</a>&gt;</sp=
an> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hive CLI has a -i &lt;file&=
gt; option. We create a pre.sql file with hive settings and then specify:<d=
iv>
<font face=3D"courier new, monospace">hive -i pre.hql -f query.hql</font><d=
iv><div class=3D"h5"><br><div class=3D"gmail_extra"><br>
<br><div class=3D"gmail_quote">On Mon, Jun 16, 2014 at 2:52 PM, Jinyuan Zho=
u <span dir=3D"ltr">&lt;<a href=3D"mailto:zhou.jinyuan@gmail.com" target=3D=
"_blank">zhou.jinyuan@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi,=C2=A0<div>I like to inc=
lude common settings in one place when I run different hql script via hive =
cli.</div>


<div>My setting is really script specific, with my understanding of hive, h=
adoop, =C2=A0it is not very appropriate to put =C2=A0these settings in hive=
-site.xml, or hadoop configruation files. I don&#39;t want to repeat these =
settings in every hql script either. I know pig has a mechinizsm to importi=
ng pig script into another script. Is there similar mechnism for hive?</div=
>



<div>Thanks,</div><span><font color=3D"#888888"><div><div><br></div>-- <br>=
-- Jinyuan (Jack) Zhou</div></font></span></div></blockquote></div>
</div></div></div></div></div>
</blockquote></div><br></div>

--089e0118243aa25cfd04fbf89bff--