Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Critical alert for Hive metastore process

avatar
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

avatar
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

avatar
Master Mentor

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

avatar
Contributor

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

avatar
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.

avatar
New Contributor

Thanks a lot! After I restarted Atlas service it worked

avatar
New Contributor

Thanks Vedant. Your answer really helped!

avatar

This post is really helpful. Thanks a lot. Prem

avatar

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