[
https://issues.apache.org/jira/browse/PHOENIX-1127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14078306#comment-14078306
]
James Taylor commented on PHOENIX-1127:
---------------------------------------
How are you loading data? Can you post the SQL code? I assume your using our
TO_DATE(dateAsString) function to attempt to load it. Replace that with
CAST(dateAsLong AS DATE).
> 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)