Examples of org.apache.pig.piggybank.evaluation.datetime.convert.ISOToUnix

org.apache.pig.piggybank.evaluation.datetime.convert.ISOToUnix

time.sourceforge.net/ ISO8601 Date Format: http://en.wikipedia.org/wiki/ISO_8601 Unix Time: http://en.wikipedia.org/wiki/Unix_time Example usage: REGISTER /Users/me/commiter/piggybank/java/piggybank.jar ; REGISTER /Users/me/commiter/piggybank/java/lib/joda-time-1.6.jar ; DEFINE ISOToUnix org.apache.pig.piggybank.evaluation.datetime.convert.ISOToUnix(); ISOin = LOAD 'test.tsv' USING PigStorage('\t') AS (dt:chararray, dt2:chararray); DESCRIBE ISOin; ISOin: {dt: chararray,dt2: chararray} 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) ... toUnix = FOREACH ISOin GENERATE ISOToUnix(dt) AS unixTime:long; DESCRIBE toUnix; toUnix: {unixTime: long} DUMP toUnix; (1231290421000L) (1202263562000L) (1173063903000L) ...

    public void testISOToUnix() throws Exception {


        // Verify that ISO string datetimes convert to Unix (long) datetimes
        Tuple t2 = TupleFactory.getInstance().newTuple(1);
        t2.set(0, "2009-01-07T01:07:01.000Z");
        ISOToUnix func2 = new ISOToUnix();
        Long unix = func2.exec(t2);


        assertTrue(unix == 1231290421000L);


    }

Examples of org.apache.pig.piggybank.evaluation.datetime.convert.ISOToUnix

Related Classes of org.apache.pig.piggybank.evaluation.datetime.convert.ISOToUnix