Spill files filling up /tmp on server

Spill files are presently written to /tmp folder by default.
While testing out AMBARI-5707, prototype with around 3 million rows written per hour and 250K rows queried at 5 minutes boundary, the spill files actually filed up disk space on root partition.

Need an option to change the write path for spill files.