Examples of YearsBetween

org.apache.pig.builtin.YearsBetween
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)

Examples of org.apache.pig.builtin.YearsBetween

    public void testDiffDateTime() throws Exception {
        Tuple t = TupleFactory.getInstance().newTuple(2);
        t.set(0, new DateTime("2009-01-07T00:00:00.000Z"));
        t.set(1, new DateTime("2002-01-01T00:00:00.000Z"));


        YearsBetween func1 = new YearsBetween();
        Long years = func1.exec(t);
        System.out.println("Years: " + years.toString());
        Assert.assertEquals(years.longValue(), 7L);
        
        MonthsBetween func2 = new MonthsBetween();
        Long months = func2.exec(t);

View Full Code Here

Examples of org.apache.pig.builtin.YearsBetween

    public void testDiffDateTime() throws Exception {
        Tuple t = TupleFactory.getInstance().newTuple(2);
        t.set(0, new DateTime("2009-01-07T00:00:00.000Z"));
        t.set(1, new DateTime("2002-01-01T00:00:00.000Z"));


        YearsBetween func1 = new YearsBetween();
        Long years = func1.exec(t);
        System.out.println("Years: " + years.toString());
        Assert.assertEquals(years.longValue(), 7L);
        
        MonthsBetween func2 = new MonthsBetween();
        Long months = func2.exec(t);

View Full Code Here

Examples of org.apache.pig.builtin.YearsBetween

    public void testDiffDateTime() throws Exception {
        Tuple t = TupleFactory.getInstance().newTuple(2);
        t.set(0, new DateTime("2009-01-07T00:00:00.000Z"));
        t.set(1, new DateTime("2002-01-01T00:00:00.000Z"));


        YearsBetween func1 = new YearsBetween();
        Long years = func1.exec(t);
        System.out.println("Years: " + years.toString());
        Assert.assertEquals(years.longValue(), 7L);
        
        MonthsBetween func2 = new MonthsBetween();
        Long months = func2.exec(t);

View Full Code Here

Examples of org.apache.pig.builtin.YearsBetween

    public void testDiffDateTime() throws Exception {
        Tuple t = TupleFactory.getInstance().newTuple(2);
        t.set(0, new DateTime("2009-01-07T00:00:00.000Z"));
        t.set(1, new DateTime("2002-01-01T00:00:00.000Z"));


        YearsBetween func1 = new YearsBetween();
        Long years = func1.exec(t);
        System.out.println("Years: " + years.toString());
        Assert.assertEquals(years.longValue(), 7L);
        
        MonthsBetween func2 = new MonthsBetween();
        Long months = func2.exec(t);

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.