Required external components
The Hive Metastore requires a backend SQL database. Supported databases and versions are:
-
MySQL 5.6.17 and above
-
Postgres 9.1.13 and above
-
Oracle 11g and above
-
MS SQL Server 2008 R2 and above
Reference: Hive Metastore documentation
The Stackable product images for Apache Hive come with built-in support for PostgreSQL. See Database drivers for details on how to make drivers for other databases (supported by Hive) available.