question What processor I need to use to clear all flowfiles and proceed to the next processor? in Support Questions https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382297#M244535 <P>My previous processor group is for update and insert a table. After that, I want to use ExecuteSQL processor.</P><P>My question is: How to clear all flowfiles and proceed to the ExecuteSQL processor, so the ExecuteSQL processor only run once.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jarviszzzz_0-1705462261503.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/39443i0734E6686FBDEF9F/image-size/medium?v=v2&amp;px=400" role="button" title="jarviszzzz_0-1705462261503.png" alt="jarviszzzz_0-1705462261503.png" /></span></P><P>For example, my pic above, there are 3 flowfiles queued, it means that the ExecuteSQL processor will run 3 times? (I think). how to clear them and only run once</P> Wed, 17 Jan 2024 03:33:05 GMT jarviszzzz 2024-01-17T03:33:05Z What processor I need to use to clear all flowfiles and proceed to the next processor? https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382297#M244535 <P>My previous processor group is for update and insert a table. After that, I want to use ExecuteSQL processor.</P><P>My question is: How to clear all flowfiles and proceed to the ExecuteSQL processor, so the ExecuteSQL processor only run once.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jarviszzzz_0-1705462261503.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/39443i0734E6686FBDEF9F/image-size/medium?v=v2&amp;px=400" role="button" title="jarviszzzz_0-1705462261503.png" alt="jarviszzzz_0-1705462261503.png" /></span></P><P>For example, my pic above, there are 3 flowfiles queued, it means that the ExecuteSQL processor will run 3 times? (I think). how to clear them and only run once</P> Wed, 17 Jan 2024 03:33:05 GMT https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382297#M244535 jarviszzzz 2024-01-17T03:33:05Z Re: What processor I need to use to clear all flowfiles and proceed to the next processor? https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382451#M244590 <P>Anyone can help about this issue?</P> Fri, 19 Jan 2024 04:20:50 GMT https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382451#M244590 jarviszzzz 2024-01-19T04:20:50Z Re: What processor I need to use to clear all flowfiles and proceed to the next processor? https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382462#M244597 <P>Problem solve after reading:&nbsp;<A href="https://community.cloudera.com/t5/Support-Questions/NiFi-Trigger-a-Processor-once-after-the-Queue-gets-empty-for/td-p/381801" target="_blank">https://community.cloudera.com/t5/Support-Questions/NiFi-Trigger-a-Processor-once-after-the-Queue-gets-empty-for/td-p/381801</A></P> Fri, 19 Jan 2024 07:10:03 GMT https://community.cloudera.com/t5/Support-Questions/What-processor-I-need-to-use-to-clear-all-flowfiles-and/m-p/382462#M244597 jarviszzzz 2024-01-19T07:10:03Z