CDK-666: Fix for sporadic Hive test failures

* Adds a config to put the metastore_db directory under target/
* Adds code to drop tables and namespaces before and after tests
Typo: `dropDatabse`