GenerateTableFetch returns no results

[#1]

I'm trying to use a "GenerateTableFetch" process, but it always returns empty flow files, with no error.

When I turn on trace, it runs the following

GenerateTableFetch[id=9adb6bf3-018a-1000-517b-b3f88a43e39e] Setting CLUSTER State to {}
GenerateTableFetch[id=9adb6bf3-018a-1000-517b-b3f88a43e39e] Returning CLUSTER State: StandardStateMap[version=663, values={}]
GenerateTableFetch[id=9adb6bf3-018a-1000-517b-b3f88a43e39e] Executing SELECT COUNT(*) FROM TESTTRANSFER
GenerateTableFetch[id=9adb6bf3-018a-1000-517b-b3f88a43e39e] Returning CLUSTER State: StandardStateMap[version=663, values={}]
GenerateTableFetch[id=9adb6bf3-018a-1000-517b-b3f88a43e39e] Returning CLUSTER State: StandardStateMap[version=663, values={}]

So it just runs a COUNT(*) and then exits it seems?

When I run the same query against the ORACLE 19c database I get a count of 500k

I can't find any info that suggests Oracle isn't supported, but I can't figure out a reason it would just return nothing.

[#2 · Accepted solution]

Hi @mr80132 ,

Something I noticed about your configuration for the "GenerateTableFetch" processor is that you are not setting any value for the "Maximum-value Columns". I think you need to set at least one column name that the processor will track the max value for and fetch anything that comes with value greater than the max. Please refer to the processor description:

https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.12.1/org.apach...

if that helps please accept solution .

Thanks