[
https://issues.apache.org/jira/browse/PHOENIX-4873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16595285#comment-16595285
]
Josh Elser commented on PHOENIX-4873:
-------------------------------------
{{DateUtil.parseTimestamp()}} appears to pull off micro and nano seconds if
they're there. The problem is that psql doesn't call this method (it uses
{{DateUtil.getDateTimeParser()}} instead).
So, PTimestamp would give you the correct value (because it uses this other
method), but psql ends up always lopping off anything smaller than a
millisecond.
However, while we still want to support Java7 (do we now?), we'd have to leave
this workaround because SimpleDateFormat in that version doesn't support
anything smaller than a millisecond.
Let me spin this out to another issue...
> Document missing time and timestamp formatting configuration properties
> -----------------------------------------------------------------------
>
> Key: PHOENIX-4873
> URL: https://issues.apache.org/jira/browse/PHOENIX-4873
> Project: Phoenix
> Issue Type: Task
> Reporter: Josh Elser
> Assignee: Josh Elser
> Priority: Major
>
> [https://phoenix.apache.org/tuning.html] lacks entries for
> phoenix.query.timeFormat, phoenix.query.timestampFormat which are used by
> psql to parse out TIME and TIMESTAMP data types.
> Add them.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
