[
https://issues.apache.org/jira/browse/PIG-1314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13284603#comment-13284603
]
Thejas M Nair commented on PIG-1314:
------------------------------------
CURRENT_TIME() might be a more intuitive alias for DATETIME(NOW). I think we
can consider adding support for DATE and CURRENT_TIMESTAMP() as a next step
after adding DATETIME. We can focus on DATETIME in this jira.
I also had a look at timestamp datatype that was added to hive, to see if it
will be interoperable (through hcatalog). The only difference is that hive
timestamp type supports storing up to nano second precision, while jodatime
supports only up to millisecond. Nanoseconds are not likely to be used in most
cases, so loosing that precision when converting hive timestamp to pig datetime
should be OK in most cases. The range of years supported in both cases is also
approximately the same.
> 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: 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
