create hive metastore in Databricks with non-SQL DB

Question

create hive metastore in Databricks with non-SQL DB

Shambhu Rai 1,411

Hi Expert,

How to create Hive Metastore in Azure databricks DB

Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator

2023-07-17T14:17:00.0766667+00:00

Please refer to the steps outlined on this YouTube video.

In addition, on the "Hive External Metastore" section of this support article you will find steps to create the hive metastore.
Shambhu Rai 1,411 Reputation points

2023-07-17T14:23:42.46+00:00

Sir,

this is using sql server db... i want it to be created independently like sql server
Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator

2023-07-17T14:43:53.81+00:00

Please add SQL Server as tag in your question. I do not know an article or documentation that specify all steps when the metastore is intended to be created on SQL Server.
Shambhu Rai 1,411 Reputation points

2023-07-17T14:46:32.21+00:00

it is not sql server question ... it is hive metastore Independently without using sql server... that was the meaning of the above line
Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator

2023-07-17T15:05:43.34+00:00

I am sorry for my misunderstanding. I usually serve the Azure SQL forum so my answer was based on Azure SQL. Please consider to modify your question and add your desire to create the metadata store on a non-SQL database, so you get faster response that will better meet your expectations for this question.
PRADEEPCHEEKATLA 90,616 Reputation points Moderator

2023-07-20T09:13:59.2266667+00:00

@Shambhu Rai - Just checking in to see if the below answer 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.

3 answers

Your answer

Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator

2023-07-17T14:17:00.0766667+00:00

Please refer to the steps outlined on this YouTube video.

In addition, on the "Hive External Metastore" section of this support article you will find steps to create the hive metastore.
Shambhu Rai 1,411 Reputation points

2023-07-17T14:23:42.46+00:00

Sir,

this is using sql server db... i want it to be created independently like sql server
Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator

2023-07-17T14:43:53.81+00:00

Please add SQL Server as tag in your question. I do not know an article or documentation that specify all steps when the metastore is intended to be created on SQL Server.
Shambhu Rai 1,411 Reputation points

2023-07-17T14:46:32.21+00:00

it is not sql server question ... it is hive metastore Independently without using sql server... that was the meaning of the above line
Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator

2023-07-17T15:05:43.34+00:00

I am sorry for my misunderstanding. I usually serve the Azure SQL forum so my answer was based on Azure SQL. Please consider to modify your question and add your desire to create the metadata store on a non-SQL database, so you get faster response that will better meet your expectations for this question.
PRADEEPCHEEKATLA 90,616 Reputation points Moderator

2023-07-20T09:13:59.2266667+00:00

@Shambhu Rai - Just checking in to see if the below answer 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.

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

PRADEEPCHEEKATLA 90,616 Moderator

@Shambhu Rai - Thanks for the question and using MS Q&A platform.

To create a Hive Metastore in Azure Databricks, you need to follow these steps:

Create an Azure Databricks workspace.
Create a cluster in the workspace.
Install the Hive Metastore component on the cluster.
Configure the Hive Metastore to use an external database, such as Azure SQL Database or Azure Database for MySQL.
Create a database in the external database and configure the Hive Metastore to use it.

For more detailed information on how to create a Hive Metastore in Azure Databricks, you can refer to the following document: Azure Databricks: External Metastores (legacy) and Connect Azure SQL DB as External Hive Metastore to Azure Databricks Spark Cluster and SQL Endpoint.

Hope this helps. Do let us know if you any further queries.

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.

PRADEEPCHEEKATLA 90,616 Reputation points Moderator

2023-07-24T08:52:30.0433333+00:00

@Shambhu Rai - Following up to see if the above answer was helpful. 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-27T20:24:05.4466667+00:00

Sir go to the last thread.. Please test before you give ans
PRADEEPCHEEKATLA 90,616 Reputation points Moderator

2023-07-31T08:29:02.95+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?

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

create hive metastore in Databricks with non-SQL DB

3 answers

Your answer