@mbraunerde Before GetSFTP, you need this processor first:   ListSFTP    ListSFTP will send GetSFTP the the list of files to get.  Be sure to search in your NiFi Processor window, SFTP, to see all matching processors.  This works for any keyword, and I use it often.   Docs here:  https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.16.0/org.apache.nifi.processors.standard.ListSFTP/index.html     ... View more

@Nifi_Al  Use getFile/putFile to read and write in your flow.  Then If you use unpackContent against a zipped flowfile it should create individual artifacts flowfiles which can be additionally unzipped further.   Alternatively, if you can create a script to unzip recursively, you can use nifi to executeScript. Maybe even use executeProcess too. ... View more

@azg  Yes, just add the values you want in the processor configuration tab.  Click + to add new key/value pairs. ... View more

@bdworld2 Being that HDP is EOL (End of Life) and M1 chip is new and breaking anything with linux amd/64 I would recommend a different learning path.  Check out CDP and build new clusters to learn the asf components you are familiar with from HDP.     ... View more

@kumsath Yes, when i saw your post I started digging around too.  The issue here is number manipulation and type casting a "number" versus a "string". That easy gets complicated in attributes and with nifi expression language functions.   The solution i referenced would take the "number" and make a number in which the visual representation should then be correct.  Its worth a try since that execute script should be very easy to test.    The alternative is to do your "math" upstream or in an execute script processor not in updateattribute. ... View more

@kumsath This may not be the best way, but check out this solution here:   https://community.cloudera.com/t5/Support-Questions/How-correct-convert-from-Decimal-with-E-to-float-in-Apache/m-p/236511   ... View more

Right, you need another processor to extract the values to an attribute for it to work like this ${attribute}   ... View more

Excellent progress.  Can you try doing a single select to get both values?   Like this:  SELECT MAX(ID),MIN(ID) FROM FLOWFILE   If you could do that, then you could extract those values into 2 separate attributes, then feed that flowfile to the next processor in the flow.  Another alternative is to extractText for each value to an attribute, then MERGE 2 flowfiles into 1. ... View more

Ok great, then the issue is the QueryRecord.  In your flow I can see that min and max are both routes to PutSQ, not attributes of a single flowfile. Have you inspected these flowfiles to see if they contain the correct values you need?    Does it send 2 flowfiles to PutSQL?     ${min} and ${max} is an attribute syntax.  I believe you will need to get the min and max into a single flowfile and extracted as attributes to send to PutSQL ... View more