[ https://issues.apache.org/jira/browse/NIFI-4494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16474450#comment-16474450 ]
Shawn Weeks commented on NIFI-4494: ----------------------------------- We actually wrote a custom Groovy script to do effectively the same thing. Being able to fetch a single row via sql and write to attributes would be useful in a lot of cases much like the FetchHBaseRow Processor. This should be a generic FetchSQLRow or equivalent though and probably should raise an error if multiple rows are returned or provide someway to handle it. > Add a FetchOracleRow processor > ------------------------------ > > Key: NIFI-4494 > URL: https://issues.apache.org/jira/browse/NIFI-4494 > Project: Apache NiFi > Issue Type: New Feature > Components: Extensions > Environment: oracle > Reporter: Fred Liu > Priority: Major > > We encounter a lot of demand, poor data quality, no primary key, no time > stamp, and even a lot of duplicate data. But the customer requires a high > performance and accuracy. > Using GenerateTableFetch or QueryDatabaseTable, we can not meet the > functional and performance requirements. So we want to add a new processor, > it is specifically for the oracle database, able to ingest very poor quality > data and have better performance. -- This message was sent by Atlassian JIRA (v7.6.3#76005)