Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIVE Metastore HA (High Availability) MariaDB

Highlighted

HIVE Metastore HA (High Availability) MariaDB

Explorer

Could you provide steps to enable high availability for HIVE Metastore with MariaDB. Please let me know how to specify new database node name in addition to existing one in HIVE configs of Ambari.

4 REPLIES 4
Highlighted

Re: HIVE Metastore HA (High Availability) MariaDB

@Abhilash Chandrasekharan

For now, MariaDB HA is not officially supported for Hive Metastore. You could try specifying the JDBC connection string as "jdbc:mysql://<uri1>,<uri2>/hive".

Highlighted

Re: HIVE Metastore HA (High Availability) MariaDB

Explorer

I will try this @Sindhu and shall confirm.

Highlighted

Re: HIVE Metastore HA (High Availability) MariaDB

Re: HIVE Metastore HA (High Availability) MariaDB

Rising Star

Even if you can connect Hive to MariaDB HA you'll run into an issue due to lack of primary keys on some of the tables. I submitted a Jira https://issues.apache.org/jira/browse/HIVE-17306 for this issue as you can't use MySQL Clusters either with Hive.

Don't have an account?
Coming from Hortonworks? Activate your account here