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.

Error Connection Reset on Impala Shell when select table

SOLVED Go to solution
Highlighted

Error Connection Reset on Impala Shell when select table

New Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Error Connection Reset on Impala Shell when select table

New Contributor

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

1 REPLY 1

Re: Error Connection Reset on Impala Shell when select table

New Contributor

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