Re: Add Yesterday's date at runtime

2012-08-06 Thread Vinod Singh
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 wrote: > I am running *Hive 0.6 *and below is the content I have in

Add Yesterday's date at runtime

2012-08-06 Thread Techy Teck
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 UserDefinedFunct