Oracle Cloud Infrastructure Documentation

Hive HA Support

Hive High Availability (HA) is fully supported in Oracle Big Data Service is available in ODH version 2.0.10 and later.

Hive HA provides increased reliability and fault tolerance by providing two HiveServer2 instances and two Hive Metastore (HMS) instances.

  • HiveServer2 HA: Two instances of HiveServer2 ensure uninterrupted query execution in case of a server failure.
  • Hive Metastore HA: Two instances of the Hive Metastore provides seamless metadata operations and improves service reliability.

Hive HA in Different Profiles

  • Generic and Hive Profiles (Default): By default, two HiveServer2 (HS2) instances and two Hive Metastore (HMS) instances are available, ensuring high availability for both query execution and metadata management.
  • Spark and Trino Profiles (Default): For these profiles, two Hive Metastore (HMS) instances are provided by default. However, HiveServer2 (HS2) isn't included, as it's not typically required in these environments.