Hive Metastore is not enabled in databricks

Question

Shambhu Rai 1,411

HI Expert,

Hive Metastore issue error it is not enabled in databricks ... how to enable it and fix the issue

Rishikesh Singh 470 Reputation points

2023-07-12T21:04:56.6833333+00:00

Hi,

Please find below details if that helps

https://learn.microsoft.com/en-us/azure/databricks/archive/external-metastores/external-hive-metastore

please accept answer if this helped
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-07-14T06:20:02.6533333+00:00

@Shambhu Rai - Just checking in to see if the below answer provided by @Dillon Silzer helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Shambhu Rai 1,411 Reputation points

2023-07-17T13:54:08.6+00:00

it is incomplete inputs

1 answer

Rishikesh Singh 470 Reputation points

2023-07-12T21:04:56.6833333+00:00

Hi,

Please find below details if that helps

https://learn.microsoft.com/en-us/azure/databricks/archive/external-metastores/external-hive-metastore

please accept answer if this helped
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-07-14T06:20:02.6533333+00:00

@Shambhu Rai - Just checking in to see if the below answer provided by @Dillon Silzer helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Shambhu Rai 1,411 Reputation points

2023-07-17T13:54:08.6+00:00

it is incomplete inputs

Answer 1

Dillon Silzer 57,826 Volunteer Moderator

In Microsoft Azure, you can enable the Hive Metastore in Databricks by following these steps:

Go to the Azure portal (portal.azure.com) and navigate to your Databricks workspace.
Open your Databricks workspace and click on "Launch Workspace."
In the Databricks workspace, go to the "Clusters" tab.
Select the cluster on which you want to enable the Hive Metastore.
Click on the "Edit" button to edit the cluster configuration.
In the "Configuration" tab, scroll down to the "Advanced Options" section.
Under the "Spark" category, enable the "Enable Hive metastore" option.
Click on the "Confirm" or "Save" button to save the changes.

After enabling the Hive Metastore, you may need to restart your cluster for the changes to take effect.

Answer generated using ChatGPT.

If this is helpful please accept answer.

Shambhu Rai 1,411 Reputation points

2023-07-14T11:14:42.93+00:00

what is the syntax... there is not enable button available
Shambhu Rai 1,411 Reputation points

2023-07-14T14:36:06.7166667+00:00

error message:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-07-17T07:46:52.37+00:00

@Shambhu Rai - I would suggest you to inspect the driver logs, you see a stack trace that includes an error message which you are experiencing.
Kindly share the stack trace of the error message here.
Shambhu Rai 1,411 Reputation points

2023-07-17T07:50:15.77+00:00

provided step itself is incomplete... any new suggest

ion
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-07-27T05:42:30.03+00:00

@Shambhu Rai - I had provided the detailed answer here: https://learn.microsoft.com/en-us/answers/questions/1331764/create-hive-metastore-in-databricks-with-non-sql-d
Shambhu Rai 1,411 Reputation points

2023-07-27T20:25:04.7233333+00:00

Have you tested the code?? Do not and without testing... It's, not working
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-07-31T08:33:10.7833333+00:00

@Shambhu Rai - Yes, we do test the answer before we provide you. In case, if it not working for you - kindly share the screenshot along with the stack trace of the error message which you are facing?