error executing queries in hive cli and spark-shell

[#1]

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

[#2 · Accepted solution]

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