Configuring Database for Hive Metastore

The metadata for Hive tables and partitions are stored in the Hive Metastore. By default, the Hive Metastore stores all Hive metadata in an embedded Apache Derby database in the file system. The following sections describe how to configure other DBs for Hive Metastore.

CAUTION
Do not use datanucleus.schema.autoCreateAll for populating underlying databases. For more details, see prohibited usage of datanucleus.schema.autoCreateAll property .