> One notable issue I've had is the lack of variable substitution in hive > scripts. This seems to make every hive script become a script template > requiring preprocessing to replace values that must change for each run:
Interesting. In a nutshell that is why I created: https://issues.apache.org/jira/browse/HIVE-617 In the most simple case, I needed to substitute X with the current day, month or hour. At first I spent some time writing some shell scripts to generate hive scripts to run with bin/hive -f. This expanded into this complicated t-sql,bash,hive generator and I stopped myself. I settled on Hive-617 because in most cases I really only needed to do substitutions using GregorianCalendar, but I got the benefit of skipping the CLI and using Hive components QueryProcessor directly, also I could launch other MR jobs in the same Class program. I would be interested to see your groovy integration though.
