Support Questions
Find answers, ask questions, and share your expertise

HDP 2.6 HIVE meta-store failed



After i upgrade HDP 2.5 to 2.6 , Iam getting HIVE metastore below error. I dont have atlas installed. I see in HWX community to remove but i dont find option to remove that property through ambari 2.5

ERROR Metastore on failed (Traceback (most recent call last):

File "/var/lib/ambari-agent/cache/common-services/HIVE/", line 200, in execute


File "/usr/lib/python2.6/site-packages/resource_management/core/", line 155, in __init__

File "/usr/lib/python2.6/site-packages/resource_management/core/", line 160, in run

self.run_action(resource, action)

File "/usr/lib/python2.6/site-packages/resource_management/core/", line 124, in run_action


File "/usr/lib/python2.6/site-packages/resource_management/core/providers/", line 262, in action_run

tries=self.resource.tries, try_sleep=self.resource.try_sleep)

File "/usr/lib/python2.6/site-packages/resource_management/core/", line 72, in inner

result = function(command, **kwargs)

File "/usr/lib/python2.6/site-packages/resource_management/core/", line 102, in checked_call

tries=tries, try_sleep=try_sleep, timeout_kill_strategy=timeout_kill_strategy)

File "/usr/lib/python2.6/site-packages/resource_management/core/", line 150, in _call_wrapper

result = _call(command, **kwargs_copy)

File "/usr/lib/python2.6/site-packages/resource_management/core/", line 303, in _call

raise ExecutionFailed(err_msg, code, out, err)

ExecutionFailed: Execution of 'export HIVE_CONF_DIR='/usr/hdp/current/hive-metastore/conf' ; hive --hiveconf hive.metastore.uris=thrift://***** --hiveconf hive.metastore.client.connect.retry.delay=1 --hiveconf hive.metastore.failure.retries=1 --hiveconf hive.metastore.connect.retries=1 --hiveconf hive.metastore.client.socket.timeout=14 --hiveconf hive.execution.engine=mr -e 'show databases;'' returned 1. log4j:WARN No such property [maxFileSize] in org.apache.log4j.DailyRollingFileAppender.

Logging initialized using configuration in file:/etc/hive/


Failed with exception Error in configuring object

Time taken: 1.957 seconds



@suresh krish

can you check what the value for the in hive config using ambari?



@suresh krish

then Atlas hook is not an issue here, do you find any exception/error in metastore logs?


When i do a show database. i am getting

Failed with exception Error in configuring object

@suresh krish

can you add the output of following command

hive --hiveconf hive.root.logger=DEBUG,console -e "show databases;"


Debug data

Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
        at java.lang.reflect.Method.invoke(
        at org.apache.hive.common.util.ReflectionUtil.setJobConf(
        ... 22 more
Caused by: java.lang.IllegalArgumentException: Compression codec com.protegrity.hadoop.fileprotector.crypto.codec.PtyCryptoCodec not found.
        at org.apache.hadoop.mapred.TextInputFormat.configure(
        ... 27 more
Caused by: java.lang.ClassNotFoundException: Class com.protegrity.hadoop.fileprotector.crypto.codec.PtyCryptoCodec not found
        at org.apache.hadoop.conf.Configuration.getClassByName(
        ... 29 more

@suresh krish what the value for key io.compression.codecs in hdfs config using ambari?


Zip, default , snappy compression codec

@suresh krish it seems that it is taking PtyCryptoCodec from some configuration, you need to check from where it is taking this configuration, run hive -e 'set -v;' > hive.out and grep codec in hive.out to know from where it is picking the PtyCryptoCodec

; ;