[SPARK-3529] [SQL] Delete the temp files after test exit

There are lots of temporal files created by TestHive under the /tmp by default, which may cause potential performance issue for testing. This PR will automatically delete them after test exit.
Yikes, this seems a whole lot more heavy handed than just implementing test lifecycle methods with annotations.  Elsewhere in the test framework, temp files are reliably delete by:

- Invoking the standard method to get a temp dir
- ... which calls `deleteOnExit()`
- ... which also cleans up the declared test dir in an annotated cleanup method

I would really avoid use of `Signal`! It does not seem required and is inconsistent with other tests.