[
https://issues.apache.org/jira/browse/PHOENIX-1127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14245486#comment-14245486
]
James Taylor commented on PHOENIX-1127:
---------------------------------------
To override your date format string, add the following to
phoenix/bin/hbase-sites.xml:
{code}
<property>
<name>phoenix.query.dateFormat</name>
<value>yyyy-MM-dd HH:mm:ss.SSS</value>
</property>
{code}
In this case, Phoenix would expect all Date, Time, and Timestamp types to be in
this format when loaded through the CSV bulk loader. Would this match your
format?
If not, the only other workaround I can think of is to use Epoch time as I
already mentioned.
> Cannot load Timestamp(6) in CSV bulk loader
> -------------------------------------------
>
> 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.3.4#6332)
