Hi Everyone,I want to have the total sum of the lines of several files that I calculated. I used processors : GetFTP-->CountText-->ReplaceText-->MergeContent-->QueryRecord. now I have error in the configuration of QueryRecord.
How can I configure QueryRecord? If you can give me a suggestion to simplify the pipeline it would be great. here is the error :
07:26:14 WEST ERROR
QueryRecord[id=d2555423-0179-1000-01c5-69175e4b54cc] Unable to query StandardFlowFileRecord[uuid=96594164-f103-4d34-949a-2c5a50b9aa00,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1622787564383-4, container=default, section=4], offset=27694, length=2],offset=0,name=location.csv,size=2] due to
java.sql.SQLException:Error while preparing statement [SELECT SUM(cnt) as cnt FROM FLOWFILE]
org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:Error while preparing statement [SELECT SUM(cnt) as cnt FROM FLOWFILE]
