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

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

public class UDFDateDiff
extends UDF

Constructor Summary

UDFDateDiff()

Method Summary

org.apache.hadoop.io.IntWritable

evaluate(org.apache.hadoop.io.Text dateString1, org.apache.hadoop.io.Text dateString2) Calculate the difference in the number of days.

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

getResolver, setResolver

Methods inherited from class java.lang.Object

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

Constructor Detail

UDFDateDiff

public UDFDateDiff()

Method Detail

evaluate

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

Calculate the difference in the number of days. The time part of the string will be ignored. If dateString1 is earlier than dateString2, then the result can be negative.

Parameters:

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

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

Returns:

the difference in days.