Return-Path: 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 26FFC9712 for ; Mon, 9 Jul 2012 05:18:06 +0000 (UTC) Received: (qmail 50185 invoked by uid 500); 9 Jul 2012 05:18:05 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 49878 invoked by uid 500); 9 Jul 2012 05:18:04 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 49840 invoked by uid 99); 9 Jul 2012 05:18:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jul 2012 05:18:02 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jieli@cs.duke.edu designates 152.3.140.1 as permitted sender) Received: from [152.3.140.1] (HELO duke.cs.duke.edu) (152.3.140.1) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jul 2012 05:17:55 +0000 Received: from mail-yw0-f48.google.com (mail-yw0-f48.google.com [209.85.213.48]) (authenticated bits=0) by duke.cs.duke.edu (8.14.5/8.14.5) with ESMTP id q695HXG6018118 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=FAIL) for ; Mon, 9 Jul 2012 01:17:34 -0400 (EDT) X-DKIM: Sendmail DKIM Filter v2.8.3 duke.cs.duke.edu q695HXG6018118 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=cs.duke.edu; s=mail; t=1341811054; bh=XS6/9hNPyT2uMzDPP7ZlYJi//XxGnjTZP8WgHY5IQ68=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject:From: To:Cc:Content-Type; b=E76EL54AK36OC7L7rL34Mbiv9Ik3zam1OklHFQlskjYj0ZljW/5hCIK65tKICmQeJ huzJUNA17EQSwrr4Tky4CZQQ19lYRE3dDFhyxgfJtlHwk+C2j0HDgR0ubjkkQDznh0 V5CDyRlo4UKQ5le6GrHaq2qKGuT8qrZNp2OlUI0E31v+qFNcjuG5NGOi+Cw2jTFmhH PylPY4v1EN72tUrrGLeVCM8Y7LjfNtDkvGYDvZt1sVyRaLo38tkH9qtzbHXhD5GJ2s 8YD6vqYHeXW67wdYEhqUDt2E1QJ+gsdsFFCYnGB/G4yirYDIhf04LHSs6mOUgYn5rb A6W0WWdf0CCSQ== Received: by yhfq46 with SMTP id q46so10377175yhf.35 for ; Sun, 08 Jul 2012 22:17:33 -0700 (PDT) MIME-Version: 1.0 Received: by 10.50.159.135 with SMTP id xc7mr7610015igb.1.1341811053445; Sun, 08 Jul 2012 22:17:33 -0700 (PDT) Received: by 10.231.85.196 with HTTP; Sun, 8 Jul 2012 22:17:33 -0700 (PDT) In-Reply-To: References: <1074532245-1341726185-cardhu_decombobulator_blackberry.rim.net-1346140304-@b2.c15.bise7.blackberry> Date: Sun, 8 Jul 2012 22:17:33 -0700 Message-ID: Subject: Re: Specify per-query configuration via a file From: Jie Li To: user@hive.apache.org Cc: "bejoy_ks@yahoo.com" Content-Type: multipart/alternative; boundary=14dae9399de132411f04c45ebb90 --14dae9399de132411f04c45ebb90 Content-Type: text/plain; charset=ISO-8859-1 Perfect! Yeah there is a "--config" option to specify Hive configuration directory. Thanks! Jie On Sun, Jul 8, 2012 at 6:26 PM, Edward Capriolo wrote: > You can already do that hive allows you to specify different configs. Try > hive --help for more info. > > > On Sunday, July 8, 2012, Jie Li wrote: > > Thanks Bejoy. > > > > It might be very convenient to support specifying configuration using a > separate conf file, e.g. > > > > hive -f query.hql -conf conf.xml > > > > Open a jira? > > > > Jie > > > > On Sat, Jul 7, 2012 at 10:43 PM, Bejoy KS wrote: > >> > >> Hi Jie > >> > >> You can set any properties using > >> Hive> SET property.name=value; > >> Anywhere in a hive session. > >> > >> Similarly in a file you can set all the required properties before the > corresponding queries and execute all queries in the file using > >> > >> Hive -f fileName.hql > >> > >> > >> Regards > >> Bejoy KS > >> > >> Sent from handheld, please excuse typos. > >> > >> -----Original Message----- > >> From: Jie Li > >> Date: Sat, 7 Jul 2012 16:31:50 > >> To: > >> Reply-To: user@hive.apache.org > >> Subject: Specify per-query configuration via a file > >> > >> Hi all, > >> > >> Besides "-hiveconf x=y", does Hive support specifying per-query > >> configuration via a file? > >> > >> Thanks, > >> Jie > >> > >> > > > > > --14dae9399de132411f04c45ebb90 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Perfect! Yeah there is a "--config" option to specify Hive config= uration directory. Thanks!

Jie

On = Sun, Jul 8, 2012 at 6:26 PM, Edward Capriolo <edlinuxguru@gmail.com> wrote:
You can already do that hive allows you to s= pecify different configs. Try hive --help for more info.


On Sunday, July 8, 2012, Jie Li <jieli@cs.duke.edu> wrote:<= br>> Thanks Bejoy.
>
> It might be very convenient to support specifying configuratio= n using a separate conf file, e.g.
>
> hive -f query.hql -conf = conf.xml
>
> Open a jira?
>
> Jie
>
> O= n Sat, Jul 7, 2012 at 10:43 PM, Bejoy KS <bejoy_ks@yahoo.com> wrote:
>>
>> Hi Jie
>>
>> You can set any =A0prop= erties using
>> Hive> SET property.name=3Dvalue;
>> Anywhere in a hive ses= sion.
>>
>> Similarly in a file you can set all the required properties before= the corresponding queries and execute all queries in the file using
>= ;>
>> Hive -f fileName.hql
>>
>>
>> = Regards
>> Bejoy KS
>>
>> Sent from handheld, please excuse= typos.
>>
>> -----Original Message-----
>> From= : Jie Li <jieli@c= s.duke.edu>
>> Date: Sat, 7 Jul 2012 16:31:50
>> To: <user@hive.apache.org>
= >> Reply-To: user@hive.apache.org
>> Subject: Specify per-query configuration via a file
>>
>> Hi all,
>>
>> Besides "-hivecon= f x=3Dy", does Hive support specifying per-query
>> configura= tion via a file?
>>
>> Thanks,
>> Jie
>>= ;
>>
>
>

--14dae9399de132411f04c45ebb90--