PutSQL with errors

[#1]

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.

I want to purge them out, how can I do this? It's a waste to wait knowing all these will fail.

[#2 · Accepted solution]

The easiest way is to stop NiFi, delete all files in the content and flowfile repositories, then restart NiFi.