Thank you for your response.

I understand that removing the hive_metastore catalog is not supported. To provide more context, here are the details of the issue I am encountering:

We are using Unity Catalog in my workspace and no longer need the hive_metastore.

1. Cluster Mode Access: Multi Node (Shared) (Single Job Cluster)
2. Mechanism: Structured Streaming
3. Cloud Provider: AWS
4. DB Version: 15.4 LTS

I hope this information helps in diagnosing the issue. Please let me know if you need any further details or logs.

Thank you for your assistance.