Support Questions
Find answers, ask questions, and share your expertise

issue with query record processor in nifi

Solved Go to solution

issue with query record processor in nifi

Explorer

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

Accepted Solutions

Re: issue with query record processor in nifi

Super 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

Re: issue with query record processor in nifi

Super 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

Re: issue with query record processor in nifi

Explorer

Thanks .. I will check the same