[
https://issues.apache.org/jira/browse/NIFI-2518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15415409#comment-15415409
]
ASF GitHub Bot commented on NIFI-2518:
--------------------------------------
Github user olegz commented on the issue:
https://github.com/apache/nifi/pull/821
Reviewing
> AbstractDatabaseFetchProcessor Time/Timestamp Precision can causes perpetual
> reads
> ----------------------------------------------------------------------------------
>
> Key: NIFI-2518
> URL: https://issues.apache.org/jira/browse/NIFI-2518
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.0.0, 0.7.0
> Reporter: Jeremy Dyer
> Assignee: Matt Burgess
> Fix For: 1.0.0
>
>
> The AbstractDatabaseFetchProcessor.java component has a toString method in
> the return of input database timestamps. In that, if the precision is stored
> lower than milliseconds, it can cause fetch issues. So, in the
> QueryDatabaseTable processor for example, the incremental fetch when the
> precision is at TimeStamp(6) versus TimeStamp(3) will lead to perpetual
> reads. A potential work around is for the source database to either refrain
> from using precision beyond TS(3) or to leverage a view for NiFi to consume
> from.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
