Hive metastore federation, internal and external unable to connect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 09:55 AM
I enabled the internal hive on the metastore federation using this query command
CREATE CONNECTION IF NOT EXISTS internal-hive TYPE hive_metastore
OPTIONS (builtin true);
But I can't get a password or username to access the JDBC URL.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 10:37 AM
Have you tried using token as username and use a valid PAT token as your password?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 11:01 AM
Yes, I got this error.
Access denied for user 'token'@'185.59.*****' (using password: YES)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 12:10 PM
Can you share with me the JDBC connection string you are running? you can remove any sensitive data if needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 12:44 PM - edited 01-08-2025 12:46 PM
jdbc://35.23*.***:3306/organization45897****935 |
organization458975****7935 |
458975*****7935 |
35.239.**.*** |
3306 |
true |
I tried using Dbeaver to connect but it failed also
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 01:15 PM
Oh ok, so you are connecting from Databricks cluster to MySQL, on this case the username and password needs to be the one for the MySQL database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 02:12 PM
Not really, what I want to achieve is connecting to an external hive but I do want to configure the external hive on our server to be able to interact with the Databricks cluster in such a way that I could have access to thrift protocol.

