Re: datetime data type

2015-05-28 Thread Michael Howard
I wrote: I would like to have a discussion about a number of issues/questions related to support for the datetime datatype in pig. One of the broader issues I want to discuss is the continued use of joda-time http://www.joda.org/joda-time/ * JSR-310 https://jcp.org/en/jsr/detail?id=310

Re: datetime data type

2015-05-28 Thread Michael Howard
* ToDate(chararray) accepts ISO-8601 'T' timestamps, but not JDBC space ' ' timestamps ... thereby make it incompatible with hive, impala JDBC data sources ToDate use org.joda.time.format.ISODateTimeFormat to parse date string. I am open to change as long as it does not break backward

Re: datetime data type

2015-05-27 Thread Daniel Dai
On 5/22/15, 1:26 PM, Michael Howard mhow...@podiumdata.com wrote: I would like to have a discussion about a number of issues/questions related to support for the datetime datatype in pig. main topics: * ToDate(chararray) accepts ISO-8601 'T' timestamps, but not JDBC space ' ' timestamps ...

datetime data type

2015-05-22 Thread Michael Howard
I would like to have a discussion about a number of issues/questions related to support for the datetime datatype in pig. main topics: * ToDate(chararray) accepts ISO-8601 'T' timestamps, but not JDBC space ' ' timestamps ... thereby make it incompatible with hive, impala JDBC data sources ...