Error Connection Reset on Impala Shell when select table

adi135 — Fri, 16 Sep 2022 14:00:45 GMT

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?

Re: Error Connection Reset on Impala Shell when select table

adi135 — Thu, 27 Dec 2018 04:18:06 GMT

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

question Re: Error Connection Reset on Impala Shell when select table in Archives of Support Questions (Read Only)

Error Connection Reset on Impala Shell when select table

Re: Error Connection Reset on Impala Shell when select table