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

Constructors

Constructor and Description
UDFDateAdd()

Method Summary

Modifier and Type	Method and Description
Text	evaluate(DateWritable d, IntWritable days)
Text	evaluate(Text dateString1, IntWritable days) Add a number of days to the date.
Text	evaluate(TimestampWritable t, 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 Text evaluate(Text dateString1,
                     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 Text evaluate(DateWritable d,
                     IntWritable days)

evaluate

public Text evaluate(TimestampWritable t,
                     IntWritable days)