Uploaded image for project: 'Pig'
  1. Pig
  2. PIG-1310

ISO Date UDFs: Conversion, Trucation and Date Math

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.7.0
    • impl
    • None
    • Can this get in 0.7? I'm 1 hour late :)
    • iso 8601 iso8601 date time datetime jodatime

    Description

      I've written UDFs to handle loading unix times, datemonth values and ISO 8601 formatted date strings, and working with them as ISO datetimes using jodatime.

      The working code is here: http://github.com/rjurney/oink/tree/master/src/java/oink/udf/isodate/

      It needs to be documented and tests added, and a couple UDFs are missing, but these work if you REGISTER the jodatime jar in your script. Hopefully I can get this stuff in piggybank before someone else writes it this time The rounding also may not be performant, but the code works.

      Ultimately I'd also like to enable support for ISO 8601 durations. Someone slap me if this isn't done soon, it is not much work and this should help everyone working with time series.

      Attachments

        1. joda-mavenstuff.diff
          3 kB
          Dmitriy V. Ryaboy
        2. pass.patch
          89 kB
          Russell Jurney

        Issue Links

          Activity

            People

              russell.jurney Russell Jurney
              russell.jurney Russell Jurney
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 168h
                  168h
                  Remaining:
                  Remaining Estimate - 168h
                  168h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified