cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Get the thrift hive.metastore.uri for Databricks unity catalog

Akshith_Rajesh
New Contributor III

I am trying to connect to Unity catalog meta store tables using Presto 
Based on the presto documentation I need to use the below configuration to connect to delta tables in the unity catalog 

https://prestodb.io/docs/current/connector/hive.html

So from where can I get the hive metastore.URI from data bricks 

connector.name=hive
hive.metastore.uri=thrift://localhost:9083
hive.s3.aws-access-key=<s3-access-key>
hive.s3.aws-secret-key=<s3-secret-key>

#Databricks #UnityCatalog

1 REPLY 1

Kaniz
Community Manager
Community Manager

Hi @Akshith_Rajesh , In Databricks, the Hive metastore URI is not directly exposed to users. However, you can interact with the metastore using Spark SQL commands. If you're using an external metastore, the URI would be something you've configured and should have access to.

If you're trying to use the Glue Catalog as your metastore, you can enable it using the configuration spark.databricks.hive.metastore.glueCatalog.enabled=true. This configuration should be set before the cluster startup or before creating the SparkSession or SparkContext

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.