hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <>
Subject Add Yesterday's date at runtime
Date Mon, 06 Aug 2012 18:39:59 GMT
I am running *Hive 0.6 *and below is the content I have in *hivetest1.hql*file.

set mapred.output.compress=true;
set mapred.output.compression.type=BLOCK;
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

*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.

View raw message