topic Re: Can I delete hive_metastore on a Unity Catalog Workspace? in Data Governance

Can I delete hive_metastore on a Unity Catalog Workspace?

TonyUK — Mon, 13 Mar 2023 10:36:08 GMT

Hi, I have a new workspace that was converted to be controlled via Unity Catalog.

There is not data stored here as this is not in use yet, so I wanted to ask if it was safe to remove this without breaking the workspace?

Thank you

Re: Can I delete hive_metastore on a Unity Catalog Workspace?

Rishabh-Pandey — Mon, 13 Mar 2023 20:27:39 GMT

Hey @Tony Collins what do you mean my deleting hive metastore from unity catalog and why you want to delete hive metastore , if you do not want to take a use of hive metastore , you can delete tables from the hive metastore and upgrade your hive metastore tables into unity catalog, simple as that

Re: Can I delete hive_metastore on a Unity Catalog Workspace?

Lakshay — Tue, 14 Mar 2023 14:57:58 GMT

Hi @Tony Collins , If you are looking to migrate your tables from Hive Metastore, you can check this documentation: https://docs.databricks.com/data-governance/unity-catalog/migrate.html

Re: Can I delete hive_metastore on a Unity Catalog Workspace?

TonyUK — Tue, 14 Mar 2023 15:20:44 GMT

Hi, thank you both for your responses.

We are new to Databricks so the workspace(s) we have are empty, no tables/data to worry about!

The workspace did exist before we set up Unity Catalog so these were upgraded.

The reason I asked about deleting the hive_metastore was simply to not confuse users with what appears to be another catalog.

I am sorry if this is a silly question, it might be important that it remains and I just don't understand. I have more or less arrived to Unity Catalog!

Re: Can I delete hive_metastore on a Unity Catalog Workspace?

Lakshay — Tue, 14 Mar 2023 15:43:28 GMT

Hi @Tony Collins , We cannot delete the hive metastore. You have got two options:

Migrate the tables from Hive Metastore to Unity Catalog: https://docs.databricks.com/data-governance/unity-catalog/migrate.html
Use both Hive metastore and Unity catalog together. You can check this document regarding the same: https://docs.databricks.com/data-governance/unity-catalog/hive-metastore.html

Re: Can I delete hive_metastore on a Unity Catalog Workspace?

Jeffery — Tue, 05 Sep 2023 20:45:40 GMT

So I have a similar question to the OP, and is really at the essence of what I think is being asked. Once we have finished migrating all of our schemas/tables from Hive to Unity Catalog, how do we effectively disable hive and prevent users from creating anything in it and enforce that they only use catalogs governed by Unity Catalog?

Re: Can I delete hive_metastore on a Unity Catalog Workspace?

JasonThomas — Fri, 08 Sep 2023 07:50:26 GMT

As things gravitate towards Unity Catalog, it would indeed be nice to have the the ability to completely remove Hive from existing setups.