[
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)
