There is no built-in support for such things in Hive. You may like to explore possibility of doing this via shell script or something else to calculate date dynamically.
Thanks, Vinod On Tue, Aug 7, 2012 at 12:09 AM, Techy Teck <comptechge...@gmail.com> wrote: > I am running *Hive 0.6 *and below is the content I have in > *hivetest1.hql*file. > > set mapred.job.queue.name=hdmi-technology; > set mapred.output.compress=true; > set mapred.output.compression.type=BLOCK; > set mapred.output.compression.codec=org.apache.hadoop.io.compress.LzoCodec; > add jar UserDefinedFunction.jar; > create temporary function rank as 'com.example.hive.udf.Rank'; > > > insert overwrite table testingtable3 partition (dt='*20120805*') > select * from testingtable3 where dt = '*2012-08-05*'; > > > And I am running the above *hivetest1.hql* file like this from the shell > prompt- > > *hive -f hivetest1.hql* > * > * > So my question is- Is there any way to always use the yesterday's date in > the red color whenever I want to run the above *hivetest1.hql file *from > the shell prompt*.* > * > * > Any suggestions will be appreciated. >
