Hi all,

Besides "-hiveconf x=y", does Hive support specifying per-query
configuration via a file?

Thanks,
Jie

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 <[EMAIL PROTECTED]>
Date: Sat, 7 Jul 2012 16:31:50
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
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

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> Date: Sat, 7 Jul 2012 16:31:50
> To: <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> 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
>
>
>

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
>> Date: Sat, 7 Jul 2012 16:31:50
>> To: <[EMAIL PROTECTED]>
>> Reply-To: [EMAIL PROTECTED]
>> 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
>>
>>
>
>

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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> >> Date: Sat, 7 Jul 2012 16:31:50
> >> To: <[EMAIL PROTECTED]>
> >> Reply-To: [EMAIL PROTECTED]
> >> 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
> >>
> >>
> >
> >
>