topic Unable to connect internal hive metastore in Data Engineering

Unable to connect internal hive metastore

johnnwanosike — Tue, 07 Jan 2025 17:32:29 GMT

I am unable to find the correct password for the internal Hive metastore I created. The protocol used was JDBC. What is the best way to connect to it? Additionally, I want to connect to an external Hive metastore as well.

Re: Unable to connect internal hive metastore

Alberto_Umana — Tue, 07 Jan 2025 17:37:08 GMT

Hi @johnnwanosike,

How have you created the metastore? have you followed any documentation.

About external hive you can refer to: https://docs.databricks.com/ja/archive/external-metastores/external-hive-metastore.html

Re: Unable to connect internal hive metastore

johnnwanosike — Tue, 07 Jan 2025 18:26:40 GMT

My primary objective is to access Unity Catalog from an external Big Data platform. I have tried the following configuration:

"type" = "iceberg", "iceberg.catalog.uri" = "https://*********.gcp.databricks.com/api/2.1/unity-catalog/iceberg", "iceberg.catalog.type" = "rest", "databricks.host" = "https://********.gcp.databricks.com", "databricks.port" = "443", "databricks.http_path" = "sql/protocolv1/o/458975******/1220-****-hrjs4****", "databricks.token" = "dapic2753f3fd55**********", "databricks.catalog" = "demo2"

However, I am unable to establish a working connection.

As an alternative, I am considering creating an internal Hive metastore and connecting to an external Hive metastore.

Which approach would be better to achieve a working connection, and are there any recommended best practices or troubleshooting steps I should follow?