Cleaning Up Spill Directories

Dremio 15.0.0 may not automatically clean up spill directories and their files from prior releases due to changes in the underlying directory structure. The format for a spill directory is operatorname-query_id.majorfragment.threadNumber.minorFragment. For example, `esort-202aff8c-63c3-7c07-c6a7-6831baa98000.1.0.

To manually clean up residual spill directories:

  1. Search for the query-id in a directory name.

  2. Verify whether the query is running, cancelled, or killed.

  3. If it is cancelled or killed, delete the directory and its files.