Created 09-21-2022 01:00 PM
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
Created 09-22-2022 04:16 AM
@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.
Created 09-22-2022 04:16 AM
@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.