Databricks

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

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