*Problem* I created the below UserDefinedFunction to get the yesterday's day in the format I wanted as I will be passing the format into this below method from the query.
*public final class YesterdayDate extends UDF {* * * * public String evaluate(final String format) { * * DateFormat dateFormat = new SimpleDateFormat(format); * * Calendar cal = Calendar.getInstance();* * cal.add(Calendar.DATE, -1); * * return dateFormat.format(cal.getTime()).toString(); * * } * *}* So whenever I try to run the query like below by adding the jar to classpath and creating the temporary function yesterdaydate, I always get zero result back- hive> create temporary function *yesterdaydate* as 'com.example.hive.udf.YesterdayDate'; OK Time taken: 0.512 seconds Below is the query I am running- *hive> SELECT * FROM REALTIME where dt= yesterdaydate('yyyyMMdd') LIMIT 10;* *OK* * * And I always get zero result back but the data is there in that table for Aug 5th.** What wrong I am doing? Any suggestions will be appreciated. NOTE:- As I am working with Hive 0.6 so it doesn’t support variable substitution thing, so I cannot use hiveconf here and the above table has been partitioned on dt(date) column.**