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.

Hive Error

Highlighted

Hive Error

Explorer

Hello All,

Our Application has reported this error and all the application were stuck, after restarting all the applications they are back, now we are looking for rca I tried to find something but an hitting the wall, would be great if anyone can share some thoughts on it or guide on how to proceed further.

Error in writeTable org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table my_table_xx_123. Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient;

19/12/10 21:21:22 INFO hive.metastore: Trying to connect to metastore with URI thrift://myserver.com:9083
19/12/10 21:21:22 ERROR dataloaderlogger: Error in writeTable org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table network_element_kpi_nrt. Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient;
19/12/10 21:21:22 WARN hive.metastore: Failed to connect to the MetaStore Server...
19/12/10 21:21:22 INFO hive.metastore: Waiting 1 seconds before next connection attempt.
19/12/10 21:21:23 INFO hive.metastore: Trying to connect to metastore with URI thrift://myserver.com:9083
19/12/10 21:21:23 WARN hive.metastore: Failed to connect to the MetaStore Server...
19/12/10 21:21:23 INFO hive.metastore: Waiting 1 seconds before next connection attempt.
19/12/10 21:21:24 INFO hive.metastore: Trying to connect to metastore with URI thrift://myserver.com:9083
19/12/10 21:21:24 WARN hive.metastore: Failed to connect to the MetaStore Server...
19/12/10 21:21:24 INFO hive.metastore: Waiting 1 seconds before next connection attempt.
19/12/10 21:21:25 WARN client.HiveClientImpl: HiveClient got thrift exception, destroying client and retrying (0 tries remaining)
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table data_collection_logs. Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1194)

 

Thanks

 

3 REPLIES 3

Re: Hive Error

Guru
@Amn_468 ,

The error means your application can't connect to HMS service for some reason. Most likely HMS has crashed. So please check the HMS log during the time period to understand what might have happened.

Cheers
Eric

Re: Hive Error

Explorer

@EricL 

 

Thanks for your reply, I did take a look at that at the first place, but did not find anything useful. Is there anything specific error to lookout for 

Re: Hive Error

Guru
@Amn_468

It can be anything, hard to predict what we might expect. HMS might not be running at all, might be kerberos issues, might be OOM error.

You need to check the exact timing in HMS log, from 19/12/10 21:21:22 to 19/12/10 21:21:25 and see what message you can find from there.

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