Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Critical alert for Hive metastore process

Solved Go to solution
Highlighted

Critical alert for Hive metastore process

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Critical alert for Hive metastore process

Guru
@Nikolaos Stanogias

This looks like a bug in 2.3.2

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

View solution in original post

7 REPLIES 7
Highlighted

Re: Critical alert for Hive metastore process

@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

42775-aleat.jpg

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

Highlighted

Re: Critical alert for Hive metastore process

Guru
@Nikolaos Stanogias

This looks like a bug in 2.3.2

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

View solution in original post

Highlighted

Re: Critical alert for Hive metastore process

New Contributor

Thanks a lot! After I restarted Atlas service it worked

Highlighted

Re: Critical alert for Hive metastore process

New Contributor

Thanks Vedant. Your answer really helped!

Highlighted

Re: Critical alert for Hive metastore process

New Contributor

This post is really helpful. Thanks a lot. Prem

Highlighted

Re: Critical alert for Hive metastore process

New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here