Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

issue with query record processor in nifi

avatar
Contributor

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

1 ACCEPTED SOLUTION

avatar
Master Guru
@Suresh Dendukuri

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

View solution in original post

2 REPLIES 2

avatar
Master Guru
@Suresh Dendukuri

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

avatar
Contributor

Thanks .. I will check the same