[ 
https://issues.apache.org/jira/browse/PHOENIX-1127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14078780#comment-14078780
 ] 

James Taylor commented on PHOENIX-1127:
---------------------------------------

The CSV loader won't keep the milliseconds part currently. The CSV loader will 
end up going through PDataType.TIMESTAMP.toObject(String) which in turn calls 
DateUtil.parseTimestamp(String). This uses the DateUtil.DEFAULT_DATE_FORMAT 
which is "yyyy-MM-dd HH:mm:ss". You might be able to tweak this and make it 
more flexible if you want to have a go at it.

> Cannot load Timestamp(6) from oracle  Example: 10/7/2010 3:28:58.117127 PM. 
> the only option currently is to load it as string and cannot apply andy date 
> manupulations on that column.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1127
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1127
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.0.0
>         Environment: PROD
>            Reporter: Deepak Gattala
>             Fix For: 5.0.0
>
>   Original Estimate: 360h
>  Remaining Estimate: 360h
>
> cannot do any date manipulation because of this issue.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to