[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.
Is this really what `InterruptUtils` is for?  It looks likes its for interrupting a running query.  Why aren't these just part of the shutdown hook?