Databricks Community

Seth_J · 04-26-2022

I am trying to setup a Databricks SQL endpoint to connect to an external hive metastore. I have replicated my metastore spark config in the SQL endpoint, with the addition of adding the below to the configuration:spark.sql.hive.metastore.jars maven I...

Seth_J · 08-17-2022

A Microsoft engineer suggested the same. This did get the SQL Warehouse connected to the metastore. Odd as this same configuration does not work with a standard Databricks cluster.Thanks for your help!

Seth_J · 07-28-2022

I realized today what I was doing wrong.I forgot to add the mysql library in the Libraries tab of the cluster. This resolved the issue for the cluster with Databricks Runtime 10.4. I am able to connect to the metastore without issue.Is there a way to...

Seth_J · 07-27-2022

Thanks, this was a great suggestion to try to figure out what's happening behind the scenes. Unfortunately, I am at a bit of a loss on what to do next. I am getting the error:Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFou...

Seth_J · 07-06-2022

Thanks for the suggestion. I tried sslMode=Require, sslMode=REQUIRED, and sslMode=VERIFY_CA from the MySQL driver docs, but I am still receiving the same error.

Seth_J · 05-16-2022

Yes, unfortunately I haven't been able to figure it out yet. I have also reached out to some Azure reps to see if anyone there might be able to help.

Databricks Community

User Stats

User Activity

SQL Endpoint with External Hive Metastore

Re: SQL Endpoint with External Hive Metastore

Re: SQL Endpoint with External Hive Metastore

Re: SQL Endpoint with External Hive Metastore

Re: SQL Endpoint with External Hive Metastore

Re: SQL Endpoint with External Hive Metastore