Support Questions

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

error executing queries in hive cli and spark-shell

avatar
Rising Star

hello cloudera community,

 

we are having a problem accessing the hive cli of a certain user and the spark-shell too

 

when executing the query "show databases" in hive cli returns the error:

 

"FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset "

 

when executing the "show databases" query in spark-shell returns the error:

 

"org.apache.spark.sql.AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException;"

 

"WARN metastore.RetryingMetaStoreClient: MetaStoreClient lost connection. Attempting to reconnect.
org.apache.thrift.transport.TTransportException"

 

when we use beeline and run the query "show databases" it works without problem

 

could you help us with this problem?

 

we are using cloudera manager 5.16.1 and cdh 5.16.1

 

the cluster is with kerberos and sentry is managing the permissions to the cluster databases

1 ACCEPTED SOLUTION

avatar
Expert Contributor

@yagoaparecidoti It looks like this particular user does not have permission to connect to HMS. You can add this user or put "*" under this configuration : CM->Hive->Configuration->Search "hive_proxy_user_groups_list"

And then restart hive and then run "show databases" .

Another possibility could be that it is not able to locate hive-site.xml on the node required to connect to Hive Metastore.

 

View solution in original post

1 REPLY 1

avatar
Expert Contributor

@yagoaparecidoti It looks like this particular user does not have permission to connect to HMS. You can add this user or put "*" under this configuration : CM->Hive->Configuration->Search "hive_proxy_user_groups_list"

And then restart hive and then run "show databases" .

Another possibility could be that it is not able to locate hive-site.xml on the node required to connect to Hive Metastore.