[
https://issues.apache.org/jira/browse/PIG-1314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13401937#comment-13401937
]
Thejas M Nair commented on PIG-1314:
------------------------------------
bq. Several time zones may share the same UTC offset, such that when the
reverse operation is to do, it will be unknown which timezone the UTC offset
should be converted to.
Yes, it will be lossy, but the part that is important for date calculations is
preserved. The ISO spec only has offset for timezone. I don't think we have to
allow datetime field to be used for storing location information. Does JodaTime
preserve the location string ?
bq. I'm not sure whether "getAvailableIDs" returns the same time zone list on
all machines or is machine-dependent.
It depends on the release/jar
(http://joda-time.sourceforge.net/tz_update.html). As pig will be shipping this
jar to the nodes, it is ok to assume that it will be the same across all nodes
for a query. So it is safe to rely on the id for intermediate serialization.
But won't jodatime support a timezone outside this list, If the user specifies
a date using the UTC offset format ?
> Add DateTime Support to Pig
> ---------------------------
>
> Key: PIG-1314
> URL: https://issues.apache.org/jira/browse/PIG-1314
> Project: Pig
> Issue Type: Bug
> Components: data
> Affects Versions: 0.7.0
> Reporter: Russell Jurney
> Assignee: Zhijie Shen
> Labels: gsoc2012
> Attachments: PIG-1314-1.patch, PIG-1314-2.patch, joda_vs_builtin.zip
>
> Original Estimate: 672h
> Remaining Estimate: 672h
>
> Hadoop/Pig are primarily used to parse log data, and most logs have a
> timestamp component. Therefore Pig should support dates as a primitive.
> Can someone familiar with adding types to pig comment on how hard this is?
> We're looking at doing this, rather than use UDFs. Is this a patch that
> would be accepted?
> This is a candidate project for Google summer of code 2012. More information
> about the program can be found at
> https://cwiki.apache.org/confluence/display/PIG/GSoc2012
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
