Reply
New Contributor
Posts: 2
Registered: ‎12-26-2018
Accepted Solution

Error Connection Reset on Impala Shell when select table

Hi All, i'm new on Cloudera & Hadoop.

I get error on my system.
When i select table from impala-shell, i got error connection time out [before this, system is normal, and i didn't change configuration]. And then i found solution from forum and download mysql-connector-java again and apply to /usr/share/java. But after i update mysql-connector-java, i got another error :

ERROR: AnalysisException: Failed to load metadata for table: ibn.test
CAUSED BY: TableLoadingException: Failed to load metadata for table: ibn.test. Running 'invalidate metadata ibn.test' may resolve this problem.
CAUSED BY: TTransportException: java.net.SocketException: Connection reset
CAUSED BY: SocketException: Connection reset
Can anyone help me?

New Contributor
Posts: 2
Registered: ‎12-26-2018

Re: Error Connection Reset on Impala Shell when select table

i found how to solve this error :

update mysql driver > mysql-connection-java

hive --service hiveserver
hive --service metastore
service iptables stop
restart hive-server
restart impala-server
restart mysql server
invalidate metadata table
refresh table

 

i think this issue becouce connection between hive and mysql that store metastore

Announcements