Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - ENV variables from CLI


+
Sam William 2012-05-03, 06:23
Copy link to this message
-
Re: ENV variables from CLI
Nitin Pawar 2012-05-03, 06:48
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 <[EMAIL PROTECTED]> 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
> [EMAIL PROTECTED]
>
>
>
>
--
Nitin Pawar
+
Edward Capriolo 2012-05-03, 14:35
+
Sam William 2012-05-03, 17:58