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.

Can't use Hive commands, experiencing error on my CDH 6.3.1

Can't use Hive commands, experiencing error on my CDH 6.3.1

Explorer

I'm currently can't use the Hive commands like show tables, but if I check my Cloudera manager the hive services are up and running. please see the error below:

 

Hive server2 are now down

Mondi_0-1588736616074.png

due to this error :

Caused by: org.apache.hadoop.hive.metastore.api.MetaException: Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused (Connection refused)

WARNING: Hive CLI is deprecated and migration to Beeline is recommended.
hive> show tables;
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

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