Re: HiveQL scripts and input arguments

2011-05-04 Thread Jonathan Bender
Thanks everybody. More reader friendly version of that SVN doc: http://archive.cloudera.com/cdh/3/hive/language_manual/var_substitution.html On Wed, May 4, 2011 at 3:15 PM, Time Less wrote: > > Just wondering if there is native support for input arguments on Hive >> scripts. >> eg. $ bin/hive

Re: HiveQL scripts and input arguments

2011-05-04 Thread Time Less
> Just wondering if there is native support for input arguments on Hive > scripts. > eg. $ bin/hive -f script.q > Any documentation I could reference to look into this further? > A workaround: cat script.q | sed -e 's/arg1/arg1val/' | bin/hive -- Tim Ellis Riot Games

Re: HiveQL scripts and input arguments

2011-05-04 Thread Edward Capriolo
Hive 0.7.X and up supports using variables in queries. This is documented in the SVN tree. http://svn.apache.org/repos/asf/hive/trunk/docs/xdocs/language_manual/var_substitution.xml You still might need some scripting outside of hive still but in many cases this can get the job done. On Wed, Ma

Re: HiveQL scripts and input arguments

2011-05-04 Thread Tim Spence
I'm wondering the same. I didn't notice it in the documentation for 0.7. My (possibly silly) way of dealing with it is to write ruby scripts to concatenate commands like > bin/hive -e "some statement" to a shell script, then execute the shell script. Parameterized scripting would be so welcome

HiveQL scripts and input arguments

2011-05-04 Thread Jonathan Bender
Hey all, Just wondering if there is native support for input arguments on Hive scripts. eg. $ bin/hive -f script.q Any documentation I could reference to look into this further? Cheers, Jon