Package org.apache.pig.builtin

Examples of org.apache.pig.builtin.HoursBetween


 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)
2972
2973
2974
2975
2976
2977
2978
2979
2980
2981
2982
2983
        DaysBetween func4 = new DaysBetween();
        Long days = func4.exec(t);
        System.out.println("Days: " + days.toString());
        Assert.assertEquals(days.longValue(), 2563L);

        HoursBetween func5 = new HoursBetween();
        Long hours = func5.exec(t);
        System.out.println("Hours: " + hours.toString());
        Assert.assertEquals(hours.longValue(), 61512L);

        MinutesBetween func6 = new MinutesBetween();
        Long mins = func6.exec(t);
View Full Code Here
3031
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
        DaysBetween func4 = new DaysBetween();
        Long days = func4.exec(t);
        System.out.println("Days: " + days.toString());
        Assert.assertEquals(days.longValue(), 2563L);

        HoursBetween func5 = new HoursBetween();
        Long hours = func5.exec(t);
        System.out.println("Hours: " + hours.toString());
        Assert.assertEquals(hours.longValue(), 61512L);

        MinutesBetween func6 = new MinutesBetween();
        Long mins = func6.exec(t);
View Full Code Here
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
        DaysBetween func4 = new DaysBetween();
        Long days = func4.exec(t);
        System.out.println("Days: " + days.toString());
        Assert.assertEquals(days.longValue(), 2563L);

        HoursBetween func5 = new HoursBetween();
        Long hours = func5.exec(t);
        System.out.println("Hours: " + hours.toString());
        Assert.assertEquals(hours.longValue(), 61512L);

        MinutesBetween func6 = new MinutesBetween();
        Long mins = func6.exec(t);
View Full Code Here
2662
2663
2664
2665
2666
2667
2668
2669
2670
2671
2672
2673
        DaysBetween func4 = new DaysBetween();
        Long days = func4.exec(t);
        System.out.println("Days: " + days.toString());
        Assert.assertEquals(days.longValue(), 2563L);

        HoursBetween func5 = new HoursBetween();
        Long hours = func5.exec(t);
        System.out.println("Hours: " + hours.toString());
        Assert.assertEquals(hours.longValue(), 61512L);

        MinutesBetween func6 = new MinutesBetween();
        Long mins = func6.exec(t);
View Full Code Here
TOP

Related Classes of org.apache.pig.builtin.HoursBetween

  • org.apache.pig.FuncSpec
  • org.apache.pig.impl.logicalLayer.schema.Schema
  • org.apache.pig.test.TestBuiltin
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.