Jeremy Dyer created NIFI-2518:
---------------------------------

             Summary: AbstractDatabaseFetchProcessor Timestamp Precision can 
causes perpetual reads
                 Key: NIFI-2518
                 URL: https://issues.apache.org/jira/browse/NIFI-2518
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: Jeremy Dyer
            Assignee: Jeremy Dyer
             Fix For: 1.0.0, 0.7.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)

Reply via email to