Hi All, Our system uses phoenix-4.3.0 to give SQL-over-Hbase ability to end users. The system is not implemented in Java, so for each query it just spawns a subprocess to execute Sqlline and redirects its output to a file. To prevent large result file, the system will monitors size of result file periodically, and kills the java process when the size exceeds some threshold.
The problem I found is that when the query is killed, phoenix will not delete the spool files it uses. So over time, the spool files will fill the disk space. Is it a bug? Any suggestion on how to deal with it? Thanks! Regards, Dayue
