Test framework should create runtime tmp files in non-root directory

[shardulm94]

When we run hive/spark tests through the test framework, it will create some files in the root folder of the project such as

metastore_db/
derby.log
hdfs_cache/

Right now we add these to .gitignore to ignore them. We should consider setting appropriate configs so that these files are generated in tmp directories and not in the root directory.