issue with query record processor in nifi

[#1]

Hi

I am using below query in query record processor for flow files which are json based , But the casecount column is not displaying in resultant flowfiles

SELECT caseid, projectshortname,COUNT(caseid) as casecount FROM FLOWFILE GROUP BY caseid,projectshortname ORDER BY caseid DESC LIMIT 1

Please advice me on this issue

[#2 · Accepted solution]

@Suresh Dendukuri

In Record Writer controller service of QueryRecord processor make sure you are having casecount name defined with the datatype associated with it.

[#3]

Thanks .. I will check the same