hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: ENV variables from CLI
Date Thu, 03 May 2012 14:35:26 GMT
That is generally how you set hiveconf. Env variables can be accessed this way.

hive> set x=${env:HOME};
hive> set x;
x=/home/edward



On Thu, May 3, 2012 at 2:48 AM, Nitin Pawar <nitinpawar432@gmail.com> wrote:
> if you are looking at having parameters from external world to hive shells
> then i would recommend
>
> 1) define all your query set into a file
> 2) when you execute the query like hive -f hive.hql  -hiveconf
> parameter1=`echo $env-value`
> and then in the hive.hql file you can access this command line parameter
> with '${hiveconf:parameter1}'
>
> ~Nitin
>
> On Thu, May 3, 2012 at 11:53 AM, Sam William <sampd@stumbleupon.com> wrote:
>>
>> How can I read env variables from the CLI .  The basic set command might
>> not be enough for me.
>>
>>
>> Essentially this is what Im trying to do - create a .hiverc file   under
>> $HIVE_HOME/bin  so as to to create UDFs for everyone in the company to
>> access .   I d like to create the .hiverc file with  commands like
>>
>>  add jar  ${JAR_LOC}/custom_hive_udfs.jar;
>>  CREATE TEMPORARY function  BlastIt as 'com.test.hive.udf.BlastIt';
>>
>> Id prefer not to  hardcode the location of  the jar file.   What are my
>> options ?  Generating the .hiverc file everytime there s a change  can only
>> a second-best option .
>>
>>
>> Sam William
>> sampd@stumbleupon.com
>>
>>
>>
>
>
>
> --
> Nitin Pawar
>

Mime
View raw message