GenerateTableFetch returns no results

mr80132 — Fri, 15 Sep 2023 22:23:39 GMT

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.

Re: GenerateTableFetch returns no results

SAMSAL — Sat, 16 Sep 2023 14:20:52 GMT

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.apache.nifi.processors.standard.GenerateTableFetch/

if that helps please accept solution .

Thanks

question GenerateTableFetch returns no results in Support Questions

GenerateTableFetch returns no results

Re: GenerateTableFetch returns no results