CDK-633: Update hive uris

Actually, both weren't needed. The `HiveManagedDatasetRepository` doesn't delegate to the `FileSystemDatasetRepository` because it will ensure the dataset location exists. But, the call was going through the FS repo because the test call was using the `Class<E> type` variant of `create` that wasn't overridden. Overriding that correctly fixes the problem without needing to add a property or change the path.

I've also noticed that because the managed side isn't going through the FS repo but might create external tables, it needs to create the location if the table is external. So I've fixed the commit to do that also.