[
https://issues.apache.org/jira/browse/PHOENIX-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14297972#comment-14297972
]
Jeffrey Zhong commented on PHOENIX-1142:
----------------------------------------
Currently our date time parsing is quite limited and cause troubles when
importing data from other data sources.
I'm thinking to replace our default date time parsing with JODA date time
parser like the DateUtil#DATE_TIME_PARSER with a little bit more tweaks though.
Because it can parse all ISO-8601 compliant
formats(http://en.wikipedia.org/wiki/ISO_8601) & our current default format
"yyyy-MM-dd HH:mm:ss" to keep backward compatibility as following examples:
{noformat}
"2015-W05-2"
"2015-01-27T16:17:57+00:00"
"2015-01-27T16:17:57Z"
"2015-027"
"2015-W05"
"2015-01-27"
"2015-01-27 16:17:58"
"2015-01-27T16:17:59"
{noformat}
Let me post a patch later. Thanks.
> Improve CsvBulkLoadTool to parse different Date formats
> -------------------------------------------------------
>
> Key: PHOENIX-1142
> URL: https://issues.apache.org/jira/browse/PHOENIX-1142
> Project: Phoenix
> Issue Type: Improvement
> Reporter: David Kjerrumgaard
>
> Currently, the CsvBulkLoadTool uses a single 'default' format to parse dates
> from the source CSV file. This can sometimes cause issues when the date
> fields don't match this default format.
> Would it be possible to add a method for specifying / overriding the
> 'default' date format?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
