org.apache.pig.builtin

Class WeeksBetween

java.lang.Object

org.apache.pig.EvalFunc<java.lang.Long>

org.apache.pig.builtin.WeeksBetween

public class WeeksBetween
extends EvalFunc<java.lang.Long>

WeeksBetween returns the number of weeks between two DateTime objects

• Jodatime: http://joda-time.sourceforge.net/
• ISO8601 Date Format: http://en.wikipedia.org/wiki/ISO_8601

 Example usage:

 ISOin = LOAD 'test.tsv' USING PigStorage('\t') AS (datetime, dt2:datetime);

 DESCRIBE ISOin;
 ISOin: {dt: datetime,dt2: datetime}

 DUMP ISOin;

 (2009-01-07T01:07:01.000Z,2008-02-01T00:00:00.000Z)
 (2008-02-06T02:06:02.000Z,2008-02-01T00:00:00.000Z)
 (2007-03-05T03:05:03.000Z,2008-02-01T00:00:00.000Z)
 ...

 diffs = FOREACH ISOin GENERATE YearsBetween(dt, dt2) AS years,
 MonthsBetween(dt, dt2) AS months,
 WeeksBetween(dt, dt2) AS weeks,
 DaysBetween(dt, dt2) AS days,
 HoursBetween(dt, dt2) AS hours,
 MinutesBetween(dt, dt2) AS mins,
 SecondsBetween(dt, dt2) AS secs;
 MilliSecondsBetween(dt, dt2) AS millis;

 DESCRIBE diffs;
 diffs: {years: long,months: long,weeks: long,days: long,hours: long,mins: long,secs: long,millis: long}

 DUMP diffs;

 (0L,11L,48L,341L,8185L,491107L,29466421L,29466421000L)
 (0L,0L,0L,5L,122L,7326L,439562L,439562000L)
 (0L,-10L,-47L,-332L,-7988L,-479334L,-28760097L,-28760097000L)

 

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.pig.EvalFunc

EvalFunc.SchemaType

Field Summary

Fields inherited from class org.apache.pig.EvalFunc

log, pigLogger, reporter, returnType

Constructor Summary

Constructors

Constructor and Description
WeeksBetween()

Method Summary

Methods

Modifier and Type	Method and Description
boolean	allowCompileTimeCalculation() Whether the UDF should be evaluated at compile time if all inputs are constant.
java.lang.Long	exec(Tuple input) This callback method must be implemented by all subclasses.
java.util.List<FuncSpec>	getArgToFuncMapping() Allow a UDF to specify type specific implementations of itself.
Schema	outputSchema(Schema input) Report the schema of the output of this UDF.

Methods inherited from class org.apache.pig.EvalFunc

finish, getCacheFiles, getInputSchema, getLogger, getPigLogger, getReporter, getReturnType, getSchemaName, getSchemaType, getShipFiles, isAsynchronous, progress, setInputSchema, setPigLogger, setReporter, setUDFContextSignature, warn

Methods inherited from class java.lang.Object

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

Constructor Detail

WeeksBetween

public WeeksBetween()

Method Detail

exec

public java.lang.Long exec(Tuple input)
                    throws java.io.IOException

Description copied from class: EvalFunc

This callback method must be implemented by all subclasses. This is the method that will be invoked on every Tuple of a given dataset. Since the dataset may be divided up in a variety of ways the programmer should not make assumptions about state that is maintained between invocations of this method.

Specified by:

exec in class EvalFunc<java.lang.Long>

Parameters:

input - the Tuple to be processed.

Returns:

result, of type T.

Throws:

java.io.IOException

outputSchema

public Schema outputSchema(Schema input)

Description copied from class: EvalFunc

Report the schema of the output of this UDF. Pig will make use of this in error checking, optimization, and planning. The schema of input data to this UDF is provided.

The default implementation interprets the OutputSchema annotation, if one is present. Otherwise, it returns null (no known output schema).

Overrides:

outputSchema in class EvalFunc<java.lang.Long>

Parameters:

input - Schema of the input

Returns:

Schema of the output

getArgToFuncMapping

public java.util.List<FuncSpec> getArgToFuncMapping()
                                             throws FrontendException

Description copied from class: EvalFunc

Allow a UDF to specify type specific implementations of itself. For example, an implementation of arithmetic sum might have int and float implementations, since integer arithmetic performs much better than floating point arithmetic. Pig's typechecker will call this method and using the returned list plus the schema of the function's input data, decide which implementation of the UDF to use.

Overrides:

getArgToFuncMapping in class EvalFunc<java.lang.Long>

Returns:

A List containing FuncSpec objects representing the EvalFunc class which can handle the inputs corresponding to the schema in the objects. Each FuncSpec should be constructed with a schema that describes the input for that implementation. For example, the sum function above would return two elements in its list:

1. FuncSpec(this.getClass().getName(), new Schema(new Schema.FieldSchema(null, DataType.DOUBLE)))
2. FuncSpec(IntSum.getClass().getName(), new Schema(new Schema.FieldSchema(null, DataType.INTEGER)))

This would indicate that the main implementation is used for doubles, and the special implementation IntSum is used for ints.

Throws:

FrontendException

allowCompileTimeCalculation

public boolean allowCompileTimeCalculation()

Description copied from class: EvalFunc

Whether the UDF should be evaluated at compile time if all inputs are constant. This is applicable for most UDF, however, if a UDF will access hdfs file which is not available at compile time, it has to be false

Overrides:

allowCompileTimeCalculation in class EvalFunc<java.lang.Long>

Returns:

Whether or not compile time calculation is allowed, default to false to ensure legacy UDF will get the right behavior