org.apache.hadoop.hive.ql.udf
Class UDFDateAdd

java.lang.Object
  org.apache.hadoop.hive.ql.exec.UDF
      org.apache.hadoop.hive.ql.udf.UDFDateAdd

public class UDFDateAdd
extends UDF

UDFDateAdd.

Constructor Summary

UDFDateAdd()

Method Summary

org.apache.hadoop.io.Text	evaluate(org.apache.hadoop.io.Text dateString1, org.apache.hadoop.io.IntWritable days) Add a number of days to the date.
org.apache.hadoop.io.Text	evaluate(TimestampWritable t, org.apache.hadoop.io.IntWritable days)

Methods inherited from class org.apache.hadoop.hive.ql.exec.UDF

getRequiredFiles, getRequiredJars, getResolver, setResolver

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

UDFDateAdd

public UDFDateAdd()

Method Detail

evaluate

public org.apache.hadoop.io.Text evaluate(org.apache.hadoop.io.Text dateString1,
                                          org.apache.hadoop.io.IntWritable days)

Add a number of days to the date. The time part of the string will be ignored. NOTE: This is a subset of what MySQL offers as: http://dev.mysql.com/doc/refman /5.1/en/date-and-time-functions.html#function_date-add

Parameters:

dateString1 - the date string in the format of "yyyy-MM-dd HH:mm:ss" or "yyyy-MM-dd".

days - The number of days to add.

Returns:

the date in the format of "yyyy-MM-dd".

evaluate

public org.apache.hadoop.io.Text evaluate(TimestampWritable t,
                                          org.apache.hadoop.io.IntWritable days)