Hi Vijay, Eventhough that property is set to a postive value, same issue happens. Seems like NIFI first loads all the rows to RAM and write to multiple files when that property is set to a non-zero value. On the other hand, if this property is set to a very small value, a large no of flow files can be generated at once.
Thank you. Best regards, Vibhath On Mon, 10 May 2021, 9:00 am Vijay Chhipa, <vchh...@apple.com> wrote: > Hi Vibhath, > > There is this property on the processor > > *Max Rows Per Flow File* > > > Per docs: If the value specified is zero, then all rows are returned in > a single FlowFile. > Which seems to be what is happening in your case. > > > > On May 9, 2021, at 12:11 PM, Vibhath Ileperuma < > vibhatharunapr...@gmail.com> wrote: > > executeSQLRecord > > >