Critical alert for Hive metastore process

nstanogias — Tue, 15 Dec 2015 03:17:55 GMT

Hi,

Im going through the tutorial from hortonworks http://hortonworks.com/hadoop-tutorial/hello-world... but when I run a query I get the following exception:

org.apache.ambari.view.hive.client.HiveErrorStatusException: H110 Unable to submit statement. Error while processing statement: FAILED: Hive Internal Error: com.sun.jersey.api.client.ClientHandlerException(java.io.IOException: org.apache.hadoop.security.authentication.client.AuthenticationException: Authentication failed, status: 503, message: Service Unavailable) [ERROR_STATUS]

The response from hive metastore process is this one:

Metastore on sandbox.hortonworks.com failed (Execution of 'export HIVE_CONF_DIR='/usr/hdp/current/hive-metastore/conf/conf.server' ; hive --hiveconf hive.metastore.uris=thrift://sandbox.hortonworks.com:9083 --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 12. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] WARNING: Use "yarn jar" to launch YARN applications. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] Logging initialized using configuration in file:/etc/hive/2.3.2.0-2950/0/conf.server/hive-log4j.properties FAILED: Hive Internal Error: com.sun.jersey.api.client.ClientHandlerException(java.io.IOException: org.apache.hadoop.security.authentication.client.AuthenticationException: Authentication failed, status: 503, message: Service Unavailable)

Is this a security issue? Can someone help please?

Thanks

Re: Critical alert for Hive metastore process

nsabharwal — Tue, 15 Dec 2015 08:18:31 GMT

@Nikolaos Stanogias Can you make sure that you can access tables using hive cli? Are you getting that error from hive view?

Re: Critical alert for Hive metastore process

vjain — Wed, 16 Dec 2015 08:51:32 GMT

@Nikolaos Stanogias

This looks like a bug in 2.3.2

Make sure Atlas is started and out of maintenance mode. That will work.

Re: Critical alert for Hive metastore process

nstanogias — Fri, 18 Dec 2015 05:10:39 GMT

Thanks a lot! After I restarted Atlas service it worked

Re: Critical alert for Hive metastore process

skanda831 — Tue, 12 Jan 2016 15:59:39 GMT

Thanks Vedant. Your answer really helped!

Re: Critical alert for Hive metastore process

premasish_dan — Mon, 22 Feb 2016 03:34:31 GMT

This post is really helpful. Thanks a lot. Prem

Re: Critical alert for Hive metastore process

kubbomicheal — Mon, 06 Jun 2016 17:01:47 GMT

Really helpful, i had same error, Turned off maintainence mode for atlas and restarted the service. Error disappears.

Re: Critical alert for Hive metastore process

saisandeepdevop — Mon, 19 Aug 2019 12:36:38 GMT

Hi I am having the same issue, But we using hive via beeline. We are able to connect Hive via beeline and able to execute the quires

question Re: Critical alert for Hive metastore process in Archives of Support Questions (Read Only)

Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process

Re: Critical alert for Hive metastore process