question Re: issue with query record processor in nifi in Support Questions

issue with query record processor in nifi

sdendukuri — Tue, 19 Jun 2018 02:22:39 GMT

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

Re: issue with query record processor in nifi

Shu_ashu — Tue, 19 Jun 2018 02:34:59 GMT

@Suresh Dendukuri

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

Re: issue with query record processor in nifi

sdendukuri — Tue, 19 Jun 2018 05:42:14 GMT

Thanks .. I will check the same