https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-with-errors/m-p/155717#M44804 <P>I have 60,000 flow files in a PutSQL processor and I know the SQL is invalid and it is failing in chunks and waiting 1 second and moving through. I was able to empty out all the backed up queues, but this processor is slowly parsing these failed files.</P><P>I want to purge them out, how can I do this? It's a waste to wait knowing all these will fail.</P> Sat, 29 Oct 2016 04:43:13 GMT TimothySpann 2016-10-29T04:43:13Z https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-with-errors/m-p/155717#M44804 <P>I have 60,000 flow files in a PutSQL processor and I know the SQL is invalid and it is failing in chunks and waiting 1 second and moving through. I was able to empty out all the backed up queues, but this processor is slowly parsing these failed files.</P><P>I want to purge them out, how can I do this? It's a waste to wait knowing all these will fail.</P> Sat, 29 Oct 2016 04:43:13 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-with-errors/m-p/155717#M44804 TimothySpann 2016-10-29T04:43:13Z https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-with-errors/m-p/155718#M44805 <P>The easiest way is to stop NiFi, delete all files in the content and flowfile repositories, then restart NiFi.</P> Tue, 01 Nov 2016 21:10:41 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-with-errors/m-p/155718#M44805 Wynner 2016-11-01T21:10:41Z