[AMBARI-19806] After setting up hadoop credential, cannot start Hive Metastore

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.5.0
• Fix Version/s: 2.5.0
• Component/s: ambari-server
• Assignee: Nahappan Somasundaram
• Reporter: Nahappan Somasundaram
• Created: 31/Jan/17 22:54
• Updated: 05/Feb/17 20:43
• Resolved: 05/Feb/17 20:43

Description

In HIVE, after javax.jdo.option.ConnectionPassword property and value is moved into a JCEKS file using hadoop credential store, hive-site.xml looks like this:

<property>
<name>hadoop.security.credential.provider.path</name>
<value>jceks://file/usr/lib/hive/conf/hive.jceks</value>
</property>

instead of:

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>MyHiveConnectionPassword</value>
</property>

However, after the above change, HIVE fails to start. This is an Ambari deployed cluster.

Traceback (most recent call last):
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", line 259, in <module>
HiveMetastore().execute()
File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 287, in execute
method(env)
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", line 59, in start
self.configure(env)
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", line 73, in configure
hive(name = 'metastore')
File "/usr/lib/python2.6/site-packages/ambari_commons/os_family_impl.py", line 89, in thunk
return fn(*args, **kwargs)
File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive.py", line 326, in hive
create_schema_cmd = format("export HIVE_CONF_DIR=

Unknown macro: {hive_server_conf_dir}

; "
File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/format.py", line 95, in format
return ConfigurationFormatter().format(format_string, args, **result)
File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/format.py", line 62, in format
result_unprotected = self.vformat(format_string, args, all_params)
File "/usr/lib64/python2.6/string.py", line 549, in vformat
result = self._vformat(format_string, args, kwargs, used_args, 2)
File "/usr/lib64/python2.6/string.py", line 575, in _vformat
obj = self.convert_field(obj, conversion)
File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/format.py", line 70, in convert_field_unprotected
return self._convert_field(value, conversion, False)
File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/format.py", line 85, in _convert_field
return utils.PASSWORDS_HIDE_STRING if is_protected else self._convert_field(value, 'e', is_protected)
File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/format.py", line 81, in _convert_field
return quote_bash_args(unicode(value))
File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/config_dictionary.py", line 73, in _getattr_
raise Fail("Configuration parameter '" + self.name + "' was not found in configurations dictionary!")
resource_management.core.exceptions.Fail: Configuration parameter 'javax.jdo.option.ConnectionPassword' was not found in configurations dictionary!

Issue Links

• links to: Review Board