Hive metastore database details missing in hive-site.xml Hive metastore database details missing in hive-site.xml hadoop hadoop

Hive metastore database details missing in hive-site.xml


JDO details are only applicable to Hive Metastore. So, for security reasons they are not included in client configuration version of hive-site.xml. The settings that you see in Cloudera Manager UI are stored in Cloudera Manager's database. CM retrieves and adds those values dynamically to a special server-side hive-site.xml which it generates before HMS process is started. That file can be seen in configuration directory /var/run/cloudera-scm-agent/process/nnn-hive-HIVEMETASTORE/ on the node running HMS role (with proper permissions; nnn here is an incremental process counter).

By the way, CDH 5.4.6 has been EOL'ed for ages. Why aren't you upgrading?