CDK-651: Throw exception if Hive cannot find the MetaStore.

Previously, Hive would connect to the local MetaStore, which should only
be used for testing. Now, the Hive integration will throw an exception
if it cannot connect to the real MetaStore. To test, this uses a new
property, kite.hive.allow-local-metastore, to avoid the exception.