File remains open when writing table data to CSV

[romlod]

I'm using the JDBC input in combination with the CSV output. When I fetch data from the table and write the data to an output CSV, it appears that the file remains open. This is a shame, because I need to move and delete that file when done. Any suggestions? I don't know if this has to do with the JDBC input or the CSV output plugin.

What I do see now is that the file closes based on the scheduler cron. So lets say you've set it to "* * * * *", the file will close after each next write actions. If you would run the cron every day, that would mean that the file remains open for an extremely long time.