Member since
09-15-2023
1
Post
0
Kudos Received
0
Solutions
09-15-2023
03:23 PM
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.
... View more
Labels:
- Labels:
-
Apache NiFi