Support Questions
Find answers, ask questions, and share your expertise

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

Highlighted

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