Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

GenerateTableFetch returns no results

avatar
New Contributor

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

Screenshot 2023-09-15 161640.jpg

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.

Screenshot 2023-09-15 161906.jpg

 

1 ACCEPTED SOLUTION

avatar

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

 

 

View solution in original post

1 REPLY 1

avatar

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